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 DirectQuery mode. Because DirectQuery does not store a copy of that data in the memory of the machine that runs the Power BI model, then Power BI Read more about Power BI Fast and Furious with Aggregations[…]

Composite Model in Power BI; DirectQuery and Import Data Combined

In the early days of developing Power BI solutions, you could choose DirectQuery or Import Data connection types, but not both. In 2018, Power BI added a breakthrough feature called Composite Model. Now, using this feature, you can have part of your Power BI dataset connected directly from a data source, and another part to Read more about Composite Model in Power BI; DirectQuery and Import Data Combined[…]

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