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

Posted on December 17, 2020December 17, 2020 by Reza Rad

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

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

Posted on December 7, 2020December 9, 2020 by Reza Rad

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

Posted on December 4, 2020December 11, 2020 by Reza Rad

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

Posted on December 1, 2020October 4, 2022 by Reza Rad

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

Posted on November 27, 2020December 21, 2021 by Reza Rad

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?

Posted on November 24, 2020November 24, 2020 by Reza Rad

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 in Power BI

Posted on November 16, 2020November 17, 2020 by Leila Etaati

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

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

Posted on November 10, 2020June 19, 2023 by Reza Rad

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

Posted on November 6, 2020November 6, 2020 by Reza Rad

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

Posted on October 30, 2020December 21, 2021 by Reza Rad

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