Forum Discussion
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 o...
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:
- Adventure Works
- 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: https://docs.microsoft.com/en-us/power-bi/service-admin-rls