Showing results for 
Search instead for 
Did you mean: 
martinmcmillz Regular Visitor
Regular Visitor

Access control for reports in apps

Is it possible to limit who has access to view parts of my app. 

I was to issue an app to the entire organisation but as it uses the same dataset as one that I want to only distribute to a handful of users, is it possible to access control the reports?

nirvana_moksh Established Member
Established Member

Re: Access control for reports in apps

You can use Row-level Security and defining that on the Queries powering the report and assign the permission to those that you wish to grant access to on the Service. So if you had the below datasets in your report:


  1. Adventure Works 
  2. Adventure Works 2


Then add RLS on both datasets and assign users (user 1, 2, 3) on the service and only they will be able to see a populated view of the report, the rest will see 'X' marks on all visuals.


This is the link to RLS:


Community Support Team
Community Support Team

Re: Access control for reports in apps

Hi @martinmcmillz

Do you publish an App to the whole organization, but there is a dataset inside this App which only a few users should have access to?

If so, nirvana_moksh's suggestion may be helpful.


Addition to his suggestion, 

please be aware of that, after publishing Power BI Desktop report to an app workspace within the Power BI service, the roles will be applied to read-only members. 

If you have configured the app workspace so that members have edit permissions, the RLS roles will not be applied to them. Users will be able to see all of the data.


Refernce here to set RLS


Best Regards


Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 309 members 3,391 guests