Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Referential Integrity

Looking for feedback on "referential Integrity" when data modeling.  My reference point is Microsoft Access.  In Access when you ensure Referential Integrity no records can be added once that selecti...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    Firstly, when connecting to a data source using DirectQuery in Power BI Desktop, you are able to use the Assume Referential Integrity feature. If you set Assume Referential Integrity when there are referential integrity issues in the data will not result in errors. However, it will result in apparent inconsistencies in the data. For more details, please review this article.

    Secondly, do you mean that you select parameter in report view of Power BI Desktop? If so, yes, it will filter out all other records in your visual  that don't meet the criteria.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

Firstly, when connecting to a data source using DirectQuery in Power BI Desktop, you are able to use the Assume Referential Integrity feature. If you set Assume Referential Integrity when there are referential integrity issues in the data will not result in errors. However, it will result in apparent inconsistencies in the data. For more details, please review this article.

Secondly, do you mean that you select parameter in report view of Power BI Desktop? If so, yes, it will filter out all other records in your visual  that don't meet the criteria.

Regards,
Lydia