A relationship setting in DirectQuery and Direct Lake models that lets the engine send faster INNER JOIN queries to the source rather than OUTER JOINs. Only switch it on when every key on the many side has a match, otherwise unmatched fact rows quietly vanish from results.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Assume referential integrity in context, with comparison tables and the common traps.
Terms in this definition
- DirectQuery
Power BI connection mode in which reports fetch data from the source in real time; Direct Lake outperforms it.
- Direct Lake
Mode for Fabric semantic models that loads Delta or Parquet files from OneLake straight into VertiPaq, giving almost import-level performance without duplicating data.
- JOIN
Combines rows from two or more tables in one SELECT, most often by pairing a primary key with the foreign key that refers to it.
- SWITCH
Checks one expression against several candidate values, returning whichever result pairs with the match (or a fallback otherwise). Writing SWITCH ( TRUE (), ... ) avoids nested IF chains: whichever condition is first true wins.
- Index field attributes
Settings applied to each field in an Azure AI Search index:
searchablefor full text,retrievableto return it,filterablefor exact-match$filter,sortable,facetablefor counts, andkeyfor the unique document ID. - MATCH
Used in WHERE when querying SQL Graph, it describes how to walk from node to node through edge tables, with patterns written like p1-(f1)->p2.