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[…]

What Happens to Your Job With the Revolution of Power BI and Self-Service BI?

The job function, market, structure, and role definition in the world of Business Intelligence had big changes throughout the past few years. The big change from traditional BI to self-service BI is not just about tools, but also about roles, and jobs, and organizational structure. In this post, I am sharing my views on this Read more about What Happens to Your Job With the Revolution of Power BI and Self-Service BI?[…]

New Video Course: DAX and Calculations in Power BI

We are pleased to let you know that our DAX and Calculations in Power BI video course is now available. This course, like many other video courses we offer, is part of the Power BI from Rookie to Rock Star training. This is a course to consider if you need to create calculations for adding Read more about New Video Course: DAX and Calculations in Power BI[…]

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[…]

Microsoft Regional Director’s Power BI Report

Over the last week of December 2019, I’ve had a bit of time to play with some free available datasets over the internet. One of them was the SQL Saturday data which I built a Power BI report for it, and another one is the Microsoft Regional Director‘s data. Let’s see what I built for Read more about Microsoft Regional Director’s Power BI Report[…]