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!

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!

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!

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

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.