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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
56 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |