There are a number of List transformations available in Power Query’s graphical interface. However, the number of functions in the graphical interface is very limited. In this post, I’m going to explain about a function that is really powerful and is not yet listed in the graphical interface. List.Accumulate is a function that loops through Read more about List.Accumulate Hidden Gem of Power Query List Functions in Power BI[…]
In previous posts, I covered some methods of Dynamic Row Level Security including Row Level Security user based, With Manager Level Access, and also with User and Profiles as a many to many relationships. In this post, I’m going to cover another common scenario for row level security; Organizational hierarchy for security. Through organizational hierarchy Read more about Dynamic Row Level Security with Organizational Hierarchy Power BI[…]
The Dynamic RLS topic is getting a good response in my blog post, so I intend to write about other types of scenarios that a security would be required. In this post, we are going to look at another type of security which deals with users and their profiles. Sometimes you have a user part Read more about Dynamic Row Level Security with Profiles and Users in Power BI : Many-to-Many Relationship[…]
It’s been a while since the last post about Power BI REST API. I have written previously about how to get the REST API, and use it in your application, how the authentication works, and things such as embedding content, and data source management. In this post, I’m going to explain one of the functionalities Read more about Integrate Power BI Into Your Application: Part 6 – Real-time Streaming and Push Data[…]
Despite all articles, blog posts, and videos on the topic of DAX Measures and Calculated columns, I still hear here and there that people ask what is the difference between Measure and Calculated Column? What situation should we use each of these? and on the other hand, what is the difference of creating column here, Read more about Measure vs Calculated Column: The Mysterious Question? Not![…]
Earlier this month (September 2017), in the new version of Power BI Desktop, a new type of chart announced; Ribbon Chart. The very first look and feel of this chart are similar to Stacked Column Chart. The question that might come into your mind is that; why another way of showing the same thing? The Read more about Ribbon Chart is the Next Generation of Stacked Column Chart[…]
A couple of months ago, I’ve written a blog post about Basics of M and explained few basics about this language. In this post, I’m going to the next step and will explain few other structure definitions in this language. In this post, you will learn about Tables, Records, Lists, and how to navigate through Read more about Basics of Value Structures in M – Power Query Formula Language[…]
In last two steps you learned how you can create a date dimension that has calendar columns, and fiscal columns. In this step we are going to look at how Power Query can be leveraged to fetch public holidays live from APIs, and add that information into the date dimension. This step shows the importance Read more about Create a Date Dimension in Power BI in 4 Steps – Step 3: Public Holidays[…]
In step 1 of creating date dimension I explained how to create the base query with calendar columns. In this post I will explain how to add fiscal columns calculated in the date dimension. Many of business reports generates on fiscal year, fiscal quarter, and fiscal period, so having fiscal columns is important part of Read more about Create a Date Dimension in Power BI in 4 Steps – Step 2: Fiscal Columns[…]
I have written multiple blog posts so far about creating a date dimension. However, I still get the question about how to create a date dimension. In this series of blog posts I am going to explain in details how you can create a date dimension easily in Power BI (based on Power Query). this Read more about Create a Date Dimension in Power BI in 4 Steps – Step 1: Calendar Columns[…]