Skip to main content
Microsoft Idea

Power BI

New

Ability to Disable RLS on DIRECT sources in Composite Model

Vote (2) Share
Santhosh Kumar Alladi's profile image

Santhosh Kumar Alladi on 18 Nov 2022 13:35:22

We have a Composite Model where majority of the tables are in Dual Mode, then 1 fact table in import and another fact table in DIRECT mode with user defined aggregation.

RLS is applied and it's working very well with dimensions and imported Fact table combination.

However, the main issue for us is that RLS is applied on Data Source as well. There are too many queries triggered to the backend due to RLS in Power BI for DIRECT query based which are not at all needed as RLS is already applied on Data Source.


There should be a feature to disable RLS on Power BI side for DIRECT query sources in a Composite Model.

Else there is no benefit of composite models where there is RLS on Power BI as well.