Forum Discussion
Solved
Filter list of Datasets which are using RLS
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 i...
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_PERMISSIONSIf 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.