How to modify a linked entity in Power BI dataflows

It is not possible to change a linked entity in a dataflow in Power BI. Linked entities has to be modified only in the dataflow in which they are created. However, sometimes, you need to do a small modification to the linked entity in a chained dataflow. There is a very simple trick, In this Read more about How to modify a linked entity in Power BI dataflows[…]

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

Showing an alternate text when no data available in a Power BI chart visuals

If you have a visual in the Power BI, that based on some selections of a slicer it might return nothing, depends on the visual, you might get a blank visual, or some other types of improper view. In this blog, I share a simple trick that you can use to have an alternate message Read more about Showing an alternate text when no data available in a Power BI chart visuals[…]