Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi @Zubair_Muhammad @Anonymous ,
What is the use of assume referential integrity in power BI?
Thaks,
-Arul
Solved! Go to Solution.
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.
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.
Hi @MattAllington ,
Can u pls explain me what is the advantage and disadvantage of using assuming referential integrity ?
Thanks,
-Arul
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.
Thank you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |