cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Soundappan
Frequent Visitor

Row Level Security

Hi Community,

 

I created the Report in PowerBi desktop and Published in the PowerBI service. In the workspace  we have 4 users each of them from different region, I need to set the RLS from the user table. The requirement is I should not use the available option "Manage Roles" in PowerBi desktop.

 

KIndly share your thoughts!!!

Thanks

1 ACCEPTED SOLUTION
Ailsa-msft
Community Support
Community Support

Hi @Soundappan 

If you want to use RLS in your report , "Manage Roles" is required . If you don’t want to use “Manage Roles”, you need to create different reports for these users and assign them access rights to different reports .

Another situation is that your data modeling and role permissions are handled in the data source, then you can set RLS directly in the data source without setting it in Desktop. You can refer to the case of applying RLS in SSAS

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-tutorial-row-level-security-onprem-ss...

 

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Ailsa-msft
Community Support
Community Support

Hi @Soundappan 

If you want to use RLS in your report , "Manage Roles" is required . If you don’t want to use “Manage Roles”, you need to create different reports for these users and assign them access rights to different reports .

Another situation is that your data modeling and role permissions are handled in the data source, then you can set RLS directly in the data source without setting it in Desktop. You can refer to the case of applying RLS in SSAS

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-tutorial-row-level-security-onprem-ss...

 

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

aj1973
Community Champion
Community Champion

@Soundappan 

In that case the (No RLS), create 4 different reports for each region and publish them to 4 different workspaces and give access to every one separatly. 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

bcdobbs
Super User
Super User

Can you explain why you can't use manage roles? If you have a user table you're talking about dynamic RLS but the logic still needs to be recorded in a role. Everyone just gets added to that one role.

 

Have you seen:

https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors