cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tilda
New Member

different reading permissions to different users

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 

 

1 ACCEPTED SOLUTION
Sumanth_23
Super User II
Super User II

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!

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



View solution in original post

3 REPLIES 3
Sumanth_23
Super User II
Super User II

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!

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



View solution in original post

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!

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors