Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |