Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
We are developing our reports in power bi report server. Our report has all the information related to sales. Currently the report can only be viewed by the sales teams users. Row level security is enabled for these users. Now we got a requirement like The Business users or the Managers from the different teams need to view this report. When ever a business user is logging in the complete report is showing the blank values as the row level security is enabled only for sales teams users.
Is it possible to proxy a business user with any of the sales teams members so a business user can be able to see the data in the report. Need help asap.
Thanks,
Hemanth
Solved! Go to Solution.
Yes, it is possible.
You can create additional ROLE for managers, which will not be affected by RLS. It is quick and simple solution.
Or you can enhance RLS, to show rows, not only by simple compare current user and row owner, but you can use e.g. organisational hierarchy, to enable manager see data of their memerships. It is more advanced solution.
Yes, it is possible.
You can create additional ROLE for managers, which will not be affected by RLS. It is quick and simple solution.
Or you can enhance RLS, to show rows, not only by simple compare current user and row owner, but you can use e.g. organisational hierarchy, to enable manager see data of their memerships. It is more advanced solution.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |