Dataflow is the data transformation service in Power BI, and also some other Power Platform services. Data Warehouse is the cloud storage and also compute engine for data. I often get this question that: “Now that we have dataflow in Power BI, should we not use the Data warehouse? What are the differences? which is Read more about Power BI Dataflow vs Data Warehouse: Which one to choose?[…]
With the DirectQuery to Power BI or Azure analysis services dataset, there are some limitations on the way that RLS (Row-level security) works. Considering that I have written a book and many blogs on this subject, It was fair to have a look at how this works. In this blog and video, you will learn Read more about Row-Level Security on a DirectQuery to Power BI dataset composite model: My Findings[…]
In my previous article and video, I explained why DirectQuery for a Power BI dataset is an important feature. In this blog and video, I explain how this feature works step by step. Prerequisite Before understanding how this feature works, I recommend reading below to understand WHY this is a game-changing important feature: Not from Read more about DirectQuery for Power BI dataset: How does it work?[…]
Are you underpaid? or you are getting paid in the market range? If you are looking for a job, what range of salary you should be looking for? The Salary survey and the report is helpful to answer these questions. A salary survey is a form that everyone fills, and from the result of that, Read more about Power BI Salary Survey and Report 2021[…]
At the end of the year 2020, we have a gift for you. Version 11 of Power BI helper has some amazing new features as below; Documentation Customization of the style Customization of the items to be exported Formatting DAX expressions in the document List of all visuals for every page Showing the measure dependency Read more about Power BI Helper Version 11 Feature Summary[…]
The news of the latest update of Power BI Desktop, December 2020, is now everywhere. Especially the most exciting feature of all is the DirectQuery for Power BI datasets and analysis service, or in other terms composite model for Power BI datasets. However, you might ask, what that mean? what is it? and how it Read more about DirectQuery for Power BI datasets and Analysis Services. The composite model with Analysis Services. What is it and why it is a big deal?[…]
One of the questions I normally get after presenting about aggregations in Power BI is that, does the aggregation works only for Composite mode and in scenarios to speed up the DirectQuery? or does it work in import mode as well? This article is about this question and shows how you can speed up your Read more about Aggregation to speed up the performance of a Power BI report even if all IMPORTED[…]
Anomaly detection is one of the popular topics in machine learning to detect uncommon data points in the datasets. For example, in a greenhouse, the temperature and other elements of the greenhouse may change suddenly and impact the plant’s health situation. Identifying the anomaly data in a credit card transaction, or in health data received Read more about Anomaly Detection in Power BI[…]
Regarding using Charticulator for creating custom visuals, I come across one of the visuals in the Charticulator gallery and I decided to follow it up to see how it created. So I manage to create a dataset that has ranking, name and amount. https://charticulator.com/gallery/co2_emission_ranking.html In this example, I am using Carbon dioxide emission data for Read more about Ranking Chart in power BI Desktop Using Charticulator[…]
I have written previously provided an all-in-one script for the date dimension, and also wrote an article about the relative date slicer. However, sometimes you cannot use the relative date slicer (timezone issue can be one example), adding offset columns help to overcome that challenge, and still be able to do flexible relative filtering in Read more about Offset Columns for the Date Table: Flexibility in Relative Date Filtering for Power BI[…]