Forum Discussion
Super UserExporting Power BI Row-Level Security Details by Workspace
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-export-to-csv/ 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
4 Replies
- 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-monitor-analysis-services?view=asallproducts-allversionsBut 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
