Forum Discussion

Super User

2 years ago

Exporting 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-de...

Super User

2 years ago

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-allversions

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

Super User

2 years ago

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
Super User
2 years ago
I just updated the question.
I will gather more information about the need and get back to you.

Forum Discussion

Exporting Power BI Row-Level Security Details by Workspace

Related content

Row Level Security Errors

Dynamic Row level security

Row level security

Dynamic Row level security issue

Row Level Security