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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
SPradeep
New Member

Row Level Security (RLS) on datasets

Hi team,

 

I am in need of guidance relating a scenario we have in one of our recent execution.

 

We have dynamic RLS implemented in Power BI datasets (models basically) and hosted in PBI Service. Now within the organisation there exits two levels of user groups,

  1. Super Users (could be web authors or someone who connects the published PBI Service dataset from Desktop application)  who will consume these datasets to prepare reports. The authoring and downloading of the .pbix would not be restricted to these users.
  2. Viewers who would consume reports developed by these Super Users or Authors. The authoring and downloading of the .pbix would be restricted to these users.

We have user information as part of the dataset to lookup and filter only data relating to them, this seems perfectly all right for Viewer audience. But for the intermediate Super User (author basically) who connects to these datasets either by downloading raw .pbix from the PBI Service or use web capability to author a report will still have access to all information available as part of the extract. How can this restrictions maintained even for these Super Users?

 

Please let me know if I miss something and any directions on this would really help.

 

Thanks in advance.

Pradeep  

3 REPLIES 3
Anonymous
Not applicable

Thank you @v-lionel-msft , I understand RLS is only applicable for viewers role.

But here is a spcecial requirement where user needs to use shared dataset to build report and re-publish it,

but they should be able to see their own data and not the complete data from shared datasource. 

Is there any way to achieve this requirement ?

 

Best Regards,

Jyoti Pawar

Hi @Anonymous ,

 

Unfortunately, the current version does not support users to have both ‘edit permission’ and ‘RLS’ in the workspace.

v-lionel-msft_0-1617871816522.png

Therefore, for data security, it is necessary to clearly distinguish what each user should do. Things like creating and publishing should be left to the report developer rather than the viewer.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-lionel-msft
Community Support
Community Support

Hi @SPradeep ,

 

In the workspace of PBI Service, RLS can not take effect on roleswith editing permission (Admin, member, contributor) .

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.