Forum Discussion
Arul
7 years agoSuper User
assume referential integrity
Hi Zubair_Muhammad Anonymous , What is the use of assume referential integrity in power BI? Thaks, -Arul
- 7 years ago
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.
MattAllington
7 years agoCommunity Champion
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.
Arul
7 years agoSuper User