Forum Discussion
Assume referential Integrity
Hi Anonymous
I would suggest you have a look at below articles.If you need further help,please share the sample file and your expected output.You can upload it to OneDrive and post the link here.Do mask sensitive data before uploading.
https://docs.microsoft.com/en-us/power-bi/desktop-assume-referential-integrity
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
Regards,
Hi
If I run the following
select * from GL_F_JOURNAL -- fact
where not exists
(select * from D_AC_Analysis a -- Dimension
where a.AC_Analysis_skey = gl_f_JOURNAL.Account_Suffix_Skey)
It returns no records, and there is a foreign key between the fact table and the dimension table so in my mind, Assume referential Integrity should allow me to set it
where am I going wrong, is there a limit to the number of relationships you can set this on ?
Hi Anonymous
You can use the Assume Referential Integrity selection to enable running more efficient queries against your data source. This feature has a few requirements of the underlying data, and it is only available when using DirectQuery.
For further,please have a look at the article:https://docs.microsoft.com/en-us/power-bi/desktop-assume-referential-integrity
Please check the Requirements for using Assume referential integrity.
Regards,