Currently, the referential integrity violation analysis includes all types of relationships - both regular and limited. This can lead to errors when limited relationships that span different data islands (cross-island relationships) generates queries that exceed row limits due to Direct Query mode (see sql-bi/Bravo#798).
To address this, we propose adding a new option to specify the analysis mode, such as Regular Only(default) and Full which will retain the current behavior by including all relationships.
Currently, the referential integrity violation analysis includes all types of relationships - both regular and limited. This can lead to errors when limited relationships that span different data islands (cross-island relationships) generates queries that exceed row limits due to Direct Query mode (see sql-bi/Bravo#798).
To address this, we propose adding a new option to specify the analysis mode, such as
Regular Only(default) andFullwhich will retain the current behavior by including all relationships.