RLS with Live connection to semantic Model in Power BI Desktop

[dataguy-ali]

Is it possible to implement RLS in Power BI report connected Live to the Semantic Model?

[Anonymous · Accepted solution]

Hi,

Thanks for the solution @TomMartens  provided, and i want to offer some more information for user to refet to.

hello @dataguy-ali , as @TomMartens  mentioned, if you use live connection mode, it cannot set the RLS in Power BI Desktop,if you want to set the RLS in Power BI Desktop, you need to change the connection mode from live connection to import.  but you can set the rls in your data source, such as SSAS, the RLS can work when you connect it to Power BI Desktop, you can refer to the following link about how to set it.

Dynamic row-level security with Analysis services tabular model - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TomMartens]

Hey @dataguy-ali ,

this is not possible. RLS needs to be defined in the semantic model, which is the source of the live connection. The report "only" allows to define measures.

Regards,

Tom