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[…]
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[…]
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[…]
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[…]
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?[…]
Anomaly detection is one of the popular topics in machine learning to detect uncommon data points in the datasets. For example, in a greenhouse, the temperature and other elements of the greenhouse may change suddenly and impact the plant’s health situation. Identifying the anomaly data in a credit card transaction, or in health data received Read more about Anomaly Detection in Power BI[…]
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[…]
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[…]
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[…]
Can you change the format of a measure or a value in Power BI dynamically? Is it possible to set a value to be a percentage sometimes, and sometimes to be a currency? can you change the currency format? The answer to all these questions is yes. In this short blog, I am going to Read more about Dynamically change the format of values in Power BI[…]