Age Calculation in Power BI using Power Query

Power Query has a simple way of calculating the age. However, because DAX is the popular language in many calculations in Power BI, many are not aware of this function in Power Query. In this blog article, I am going to show you how easy is to calculate Age in Power BI using Power BI. Read more about Age Calculation in Power BI using Power Query[…]

Share Different Visual Pages with Different Security Groups in Power BI

I have written a dozen of blogs and a book about Power BI row-level security and the security on the dataset. However, I always get this question that: “What if I want some people to see only a few pages of my report, and some others to see other pages?” or “How can I put Read more about Share Different Visual Pages with Different Security Groups in Power BI[…]

Get the List of FOLDERS only in Power BI using Power Query

There are times that you need to get the list of FOLDERS and not just files. Of course folder itself (without considering files in it), doesn’t contain data to be used for a report. However, sometimes, even the folder name might contain some useful information. The Get Data From Folder option in Power BI will Read more about Get the List of FOLDERS only in Power BI using Power Query[…]

Create Row Number for Each Group in Power BI using Power Query

If you want to create a row-number statically as a pre-calculation in Power BI, then Power Query has a very simple way of doing it; Add Index Column. However, the Index column creates the row number regardless of any grouping or categorization. sometimes you want to take that into account too. There is a little Read more about Create Row Number for Each Group in Power BI using Power Query[…]

Reference from Another Query in Dataflow – No Premium Needed – Power Platform Dataflows

I have previously explained one of the benefits of Power Platform dataflows, which was the ability to refresh the data as many times as you want (on a scheduled basis), and the ability to refresh even with the frequency of a minute. Another useful feature of Power Platform dataflows is the ability to have referenced Read more about Reference from Another Query in Dataflow – No Premium Needed – Power Platform Dataflows[…]

Power BI Get Data from Multiple Files in a Folder on OneDrive for Business, No Gateway Needed

I have written another blog article previously about how to set up your Power BI to get data from a file in OneDrive for Business folder without needing gateway. That was a popular blog article, but I got questions about what if I want to get data from a folder in OneDrive for business but Read more about Power BI Get Data from Multiple Files in a Folder on OneDrive for Business, No Gateway Needed[…]

Get the Image URL in Power BI Using Power Query Get Table from Example

I have written previously a blog article that I explained in detail how I fetch the image URL from a website using Power Query. That method, however, is what I call a bit of a techie way of doing it because you have to look at the HTML code of the page. There is an Read more about Get the Image URL in Power BI Using Power Query Get Table from Example[…]

Change Excel Source in Power BI to OneDrive for Business – No Gateway Needed

If you used an excel file in a local source (or even OneDrive for Business, but sourced locally), you need to do one extra step to make your query refreshable without the need to the gateway. Here in this blog post, I’ll explain an easy way to do that change. If you want to learn Read more about Change Excel Source in Power BI to OneDrive for Business – No Gateway Needed[…]

DAX Variables: Better Readability, Consistency, and Performance in Power BI Calculations

Have you ever had a scenario that you need to use part of your calculation multiple times? You might go and create a table or column for that and then re-use it. However, there are times that you just need that calculation to be re-used multiple times within one place. DAX variables can help you Read more about DAX Variables: Better Readability, Consistency, and Performance in Power BI Calculations[…]

Calculate Totals in Power BI: Using Iterators in DAX

The total value that you see in a table is not actually SUM of all values in that column, it is, in fact, the calculation, when there is no filter. This, however, might not be the calculation that we want sometimes. we might want this value to be the sum of values of that column Read more about Calculate Totals in Power BI: Using Iterators in DAX[…]