Filter list of Datasets which are using RLS

[nattanarcilla]

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.

[lbendlin · Accepted 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.