When connecting to a data source using DirectQuery, 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. Setting Assume referential integrity enables queries on the data source to use INNER JOIN statements rather than OUTER JOIN, which Read More