Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Row Level Security on Composite Model

Hello,   In my report, I have connected to SSAS cubes data, Power BI dataset and Sharepoint data. 1.Imported one table of suppliers with Supplier ID from SSAS cube and direct queried other tables ...
Need Help
ABI_Rufino's avatar
ABI_Rufino
Advocate I
2 years ago

Anonymous,

 

I was able to figure it out. When you have a connection to a Power BI dataset on a composite model, it's a limitation from the tool that you cannot make RLS work on it.

RLS must be created on the dataset that you are connection with, then it will work on your composite model.

 

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#working-with-a-composite-model-based-on-a-semantic-model

 

"RLS rules will be applied on the source on which they're defined, but won't be applied to any other semantic models in the model. RLS defined in the report won't be applied to remote sources, and RLS set on remote sources won't be applied to other data sources. Also, you can't define RLS on a table loaded from a remote source, and RLS defined on local tables will not filter any tables loaded from a remote source."

 

Regards,

Bernardo Rufino.