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 possibly filter the list of datasets in power bi service which are using RLS? Most of the reports I have are published in a single workspace, so checking the dataset if it has RLS in placed is a bit tricky because I have to check the security setting of each individual dataset.
Solved! Go to Solution.
That is a great question. Not sure if the new scanner API supports that but you can do this manually by running a couple of DMV queries against all datasets that you have access to:
select * from $SYSTEM.TMSCHEMA_ROLES
select * from $SYSTEM.TMSCHEMA_TABLE_PERMISSIONS
If this returns results then the dataset has RLS.
That is a great question. Not sure if the new scanner API supports that but you can do this manually by running a couple of DMV queries against all datasets that you have access to:
select * from $SYSTEM.TMSCHEMA_ROLES
select * from $SYSTEM.TMSCHEMA_TABLE_PERMISSIONS
If this returns results then the dataset has RLS.
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.