Forum Discussion
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 in placed is a bit tricky because I have to check the security setting of each individual dataset.
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.
1 Reply
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.