Question
You have a Fabric tenant that contains a warehouse. The warehouse uses row-level security (RLS).
You create a Direct Lake semantic model that uses the Delta tables and RLS of the warehouse.
When users interact with a report built from the model, which mode will be used by the DAX queries?
- A. DirectQuery Correct
- B. Dual
- C. Direct Lake
- D. Import
Explanation
A Direct Lake model that uses the warehouse's SQL-based RLS is Direct Lake on the SQL analytics endpoint. When the SQL analytics endpoint enforces row-level security, Direct Lake cannot read the Delta tables directly, so DAX queries fall back to DirectQuery and the warehouse applies the security. This is the default Direct Lake behavior (Automatic); if fallback is disabled, the queries fail instead. Direct Lake mode itself is used only when the data can be loaded straight from the Delta tables. Dual and Import are storage modes for other model types and are not used here.
