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

RLS in edit report.

Hi everyone,

 Our company purchase several pro licenses in order to train business user to edit the report in workspace. IT department pre-perpares the data, create measures and dimensions on desktop and publishes the report to workspace. Unfortunately, we could not control the RLS in edit

1 ACCEPTED SOLUTION
Community Support
Community Support

Hi, @qq466031461 

According to your description, I guess you mean you can’t control RLS in Editing View in Power BI Service.

The first thing you should understand is that RLS won’t work on the users who have the authority to create reports using the dataset. Therefore, I think that if you want to control the data through RLS, you should remove the editing authority from the users. What’ more, you can just create some sample data (without sensitive data) for the business users to create some simple demos.

You can click here to add users to your RLS roles in Power BI Service:

v-robertq-msft_0-1604049836611.png

 

 

More Info about RLS:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-rls

https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance

 

Best Regards,

Community Support Team _Robert Qin

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

1 REPLY 1
Community Support
Community Support

Hi, @qq466031461 

According to your description, I guess you mean you can’t control RLS in Editing View in Power BI Service.

The first thing you should understand is that RLS won’t work on the users who have the authority to create reports using the dataset. Therefore, I think that if you want to control the data through RLS, you should remove the editing authority from the users. What’ more, you can just create some sample data (without sensitive data) for the business users to create some simple demos.

You can click here to add users to your RLS roles in Power BI Service:

v-robertq-msft_0-1604049836611.png

 

 

More Info about RLS:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-rls

https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance

 

Best Regards,

Community Support Team _Robert Qin

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

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors