Row-Level Security on a DirectQuery to Power BI dataset composite model: My Findings

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

DirectQuery for Power BI dataset: How does it work?

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

Power BI Fast and Furious with Aggregations

Power BI is not only a solution for small datasets, but It also caters for big datasets. If the volume of data is huge, you can switch to the DirectQuery mode for it. Because DirectQuery does not store a copy of that data in the memory of the machine that runs Power BI model, then Read more about Power BI Fast and Furious with Aggregations[…]