Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
nattanarcilla
Frequent Visitor

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.

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.