Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.