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,
I have a powerbi desktop report that contains financial data for several countries in Europe. I would like to share this report with a wider audience, but I would like to restrict the viewing permissions like this:
- Full access to the whole Europe report -> Europe manager only
- Limited access to Country A-> Country A manager + Europe manager only
- Limited access to Country B-> Country B manager + Europe manager only
....
I would like to define this based on the "Country" field that I have in my database.
Is there a possibility for that? Or do I have to create so many reports as many countries I have?
Thanks,
Tilda
Solved! Go to Solution.
hi @tilda, you can create Row Level Security and define roles as per the combinations mentioned. The folks assigned to the specific roles will see the data as expected.
Please refer to the Mcirosoft docs link on the topic.
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Proud to be a Super User!
hi @tilda, you can create Row Level Security and define roles as per the combinations mentioned. The folks assigned to the specific roles will see the data as expected.
Please refer to the Mcirosoft docs link on the topic.
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Proud to be a Super User!
thanks, it worked great!
hi @tilda - glad to hear! 🙂
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Proud to be a Super User!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |