cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Arul Helper III
Helper III

assume referential integrity

Hi @Zubair_Muhammad  @rajendran ,

What is the use of assume referential integrity in power BI?

 

Thaks,

-Arul

1 ACCEPTED SOLUTION

Accepted Solutions

Re: assume referential integrity

It improves performance if you use it. If you use it and you don’t have referential Integrity, then you may get incorrect results. If your db has referential integrity, then use it to get better performance. If you don’t know if you do or not, or if you don’t, then don’t use it to ensure you get the correct answer in preference to a faster incorrect answer. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

4 REPLIES 4

Re: assume referential integrity

It is used with direct query mode to improve performance.   From memory. It switches from left outer joins to inner joins for the converted SQL code. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Arul Helper III
Helper III

Re: assume referential integrity

Hi @MattAllington ,

Can u pls explain me what is the advantage and disadvantage of using assuming referential integrity ?

Thanks,

-Arul

Re: assume referential integrity

It improves performance if you use it. If you use it and you don’t have referential Integrity, then you may get incorrect results. If your db has referential integrity, then use it to get better performance. If you don’t know if you do or not, or if you don’t, then don’t use it to ensure you get the correct answer in preference to a faster incorrect answer. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

Arul Helper III
Helper III

Re: assume referential integrity

@MattAllington ,

Thank you.

 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors