Exporting Power BI Row-Level Security Details by Workspace

[AmiraBedh]

Is there a way to export the RLS configured on semantic models  by workspace?

I only found this tutorial : https://www.fourmoo.com/2022/06/22/how-to-get-power-bi-row-level-security-rls-role-users-details-and... and it is not giving many details and what I understood from it, the RLS is configured in SSAS.

I have 2 situations :

- my semantic model having a source a SQL Server table

- my semantic model having a source an Azure database

I want to get a list : 

• The workspace name 
• The semantic model name
• The role name
• The role member email
• The role filter expression

[lbendlin]

Use the dedicated DMV queries for that

[AmiraBedh]

@lbendlin I assume you are refering to this : 
https://learn.microsoft.com/en-us/analysis-services/instances/use-dynamic-management-views-dmvs-to-m...

But in this case my datasets are connected (Live Query) to Azure SQL database/SQL Server.

In this case, how dedicated DMV can help ?

[lbendlin]

You said RLS and Semantic Model. You did not mention anything Azure SQL.

select * from $SYSTEM.TMSCHEMA_ROLES

select * from $SYSTEM.TMSCHEMA_ROLE_MEMBERSHIPS

[AmiraBedh]

I just updated the question.

I will gather more information about the need and get back to you.