Power BI Helper Version 11 Feature Summary

At the end of the year 2020, we have a gift for you. Version 11 of Power BI helper has some amazing new features as below; Documentation Customization of the style Customization of the items to be exported Formatting DAX expressions in the document List of all visuals for every page Showing the measure dependency Read more about Power BI Helper Version 11 Feature Summary[…]

DirectQuery for Power BI datasets and Analysis Services. The composite model with Analysis Services. What is it and why it is a big deal?

The news of the latest update of Power BI Desktop, December 2020, is now everywhere. Especially the most exciting feature of all is the DirectQuery for Power BI datasets and analysis service, or in other terms composite model for Power BI datasets. However, you might ask, what that mean? what is it? and how it Read more about DirectQuery for Power BI datasets and Analysis Services. The composite model with Analysis Services. What is it and why it is a big deal?[…]

The importance of knowing different types of Power BI users; a governance approach

Power BI users are not all in the same category. If you treat everyone the same, then you wouldn’t have a successful Power BI adoption. You would likely spend too much on the training and gain much less of adoption. In this article, I’ll explain what are the different types of users and what are Read more about The importance of knowing different types of Power BI users; a governance approach[…]

Clean Power BI model with a few clicks – Power BI Helper Version 10 Feature Summary

The most exciting feature of this version is that now with a few clicks you can clean up the Power BI model, but we have a few other things to add also; Exporting the result of DMV Partitions (Includes the M script of each table) Showing unused measures in the visualization tab showing all columns/measures Read more about Clean Power BI model with a few clicks – Power BI Helper Version 10 Feature Summary[…]

How to IMPORT data from a Power BI dataset – Premium-only

Get data from a Power BI dataset is creating a live connection, which is the recommended way, because you will get the entire model. However, sometimes you want to import the data from the model so that you can add other things to it (like another data source). The ability to have a composite model Read more about How to IMPORT data from a Power BI dataset – Premium-only[…]

Aggregation to speed up the performance of a Power BI report even if all IMPORTED

One of the questions I normally get after presenting about aggregations in Power BI is that, does the aggregation works only for Composite mode and in scenarios to speed up the DirectQuery? or does it work in import mode as well? This article is about this question and shows how you can speed up your Read more about Aggregation to speed up the performance of a Power BI report even if all IMPORTED[…]

Power BI Helper November 2020 Feature Summary

We have some bug fixes and small features that make a big improvement in using Power BI Helper. In this post, you will learn about the new features added in Power BI Helper in November 2020 edition. in a nutshell, here are updates; layout for different sizes of screen splitters for a better UI cross-filtering Read more about Power BI Helper November 2020 Feature Summary[…]

Power BI data source isolation using dataflows. How is it and what are the benefits?

Dataflows are useful for many scenarios when dealing with Power BI. One of their big advantages is the data source isolation and anything that comes with that. Benefits of such architecture are many, including datasets independent from the data source changes, and managing security in another layer from the data source. In this article, I’ll Read more about Power BI data source isolation using dataflows. How is it and what are the benefits?[…]

Dynamic Row-Level Security in Power BI with Exclude and Include Rules

In the previous article, I explained how to implement a dynamic row-level security pattern when you have a value that you want to exclude. However, what if you want to EXCLUDE at some scenarios and INCLUDE in some others? What if you want to have a role saying access to everything but New Zealand, and Read more about Dynamic Row-Level Security in Power BI with Exclude and Include Rules[…]

Dynamic Row-Level Security in Power BI with NOT IN or NOT EQUAL Rule

Sometimes when you apply the dynamic row-level security, you want to have the criteria as NOT EQUAL and NOT IN. This can be a bit tricky in the dynamic implementation of RLS, because the relationship behavior is normally the opposite. In this article I’ll explain how you can do that. Introduction I have written many Read more about Dynamic Row-Level Security in Power BI with NOT IN or NOT EQUAL Rule[…]