Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Poweraegg
Advocate II
‎08-25-2024 01:57 AM

Microsoft Power BI - Limited Relationships in Mixed Query Modes

Limited relationships are dangerous in Power BI. They come with some unexpected behaviours, and can lead to incorrect numbers on the reporting side. Without knowingly managing them, it can happen that you publish a report and have incorrect summarized values in your visuals. 

 

 

In this video we demonstrate what the impact of a limited relationship is on your data, and how to easily mitigate the risk and solve the problems at hand.

 

Furthermore, we have a look at the new directlake connection, and how it seems to be a limited relationship, when in fact it does not behave the same way as a mixed mode model that has a limited relationship.

 

Directlake still has limitations, and it is not possible to mix directlake connection with import mode or direct query. There are difficult technological challenges underneath the hood - with directlake the vertipaq engine does not translate the queries into the local columnar storage format, but can read Delta Parquet directly. With import mode and direct query, however, queries are sent in SQL to the source, and data is stored in the local vertipaq columnar storage format.

 

I hope you enjoy the video, and the quick insights into limited relationships, and the challenges they can bring.

 

from @Poweraegg