Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 :
Use the dedicated DMV queries for that
@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 ?
You said RLS and Semantic Model. You did not mention anything Azure SQL.
select * from $SYSTEM.TMSCHEMA_ROLES
select * from $SYSTEM.TMSCHEMA_ROLE_MEMBERSHIPS
I just updated the question.
I will gather more information about the need and get back to you.
User | Count |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |