Forum Discussion

manvishah17's avatar
manvishah17
Icon for Solution Supplier rankSolution Supplier
1 year ago
Solved

RLS Not Applying to DirectLake Tables After Model Becomes Composite Model

Hi Community,   We’re working with a Lakehouse in Microsoft Fabric, and our Power BI report is connected to it using DirectLake mode. All our tables come directly from the Lakehouse, and Row-Level ...
Need Help
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    Hi manvishah17  It is because when a DirectLake model becomes a Composite Model, all DirectLake tables switch to DirectQuery mode, and RLS in Power BI cannot directly apply to DirectQuery tables. RLS only works on imported tables in Composite Models. To resolve this, keep the mapping table in DirectLake mode, implement RLS at the data source, or use a lightweight DirectLake RLS table Or preprocess data using Power BI Dataflows to enforce RLS.

Akash_Varuna's avatar
Akash_Varuna
Icon for Super User rankSuper User
1 year ago

Hi manvishah17  It is because when a DirectLake model becomes a Composite Model, all DirectLake tables switch to DirectQuery mode, and RLS in Power BI cannot directly apply to DirectQuery tables. RLS only works on imported tables in Composite Models. To resolve this, keep the mapping table in DirectLake mode, implement RLS at the data source, or use a lightweight DirectLake RLS table Or preprocess data using Power BI Dataflows to enforce RLS.