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

Row Level Security - Report That Uses Dataset

Hi All,

 

I was hoping I could get some clarification around an issue I've been having trying to test Row Level Security.

 

Up until now, any of my reports that have used Row Level Security have pulled in data using SQL server queries. The Roles have been made within the report itself, and I have published these to the Power BI Service & been able to test the roles here wthout any issues.

 

For my most recent report, I have created a dataflow, and then a dataset off this dataflow. The Row Level Security roles are now created in the dataset itself, and I am then building a report off this dataset. 

When I publish the dataset to the Power BI Service, I can test the Row Level Security here as normal. However, when I publish the report that points to the dataset to the Power BI Service, there is no option here to test the Row Level Security on the report itself. I need this in order to verify the visuals/data being displayed in the report will in fact only display to the right people etc., but currently cannot see a way to do this.

 

Is there a way around this so that I can test RLS on the report in the Power BI Service (i.e. the end product which will 'go live'), instead of just on the dataset?

 

Many thanks in advance!

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

Hi. I don't think you can at all. The testing of the RLS is done in the dataset only. The reports connected are going to be filtered by RLS, yes. If you want to try on the exact development you can copy all the visualizations in your report page and paste it in the dataset file to try it. 

Please remember that RLS is only applied to users without building permission (only viewers). Make sure you are not giving building access for those you want RLS to be applied.

I hope that helps,


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

Happy to help!

LaDataWeb Blog

View solution in original post

2 REPLIES 2
ibarrau
Super User
Super User

Hi. I don't think you can at all. The testing of the RLS is done in the dataset only. The reports connected are going to be filtered by RLS, yes. If you want to try on the exact development you can copy all the visualizations in your report page and paste it in the dataset file to try it. 

Please remember that RLS is only applied to users without building permission (only viewers). Make sure you are not giving building access for those you want RLS to be applied.

I hope that helps,


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

Happy to help!

LaDataWeb Blog

View solution in original post

Hi ibarrau,

 

That makes sense, thanks so much for answering & for the testing suggestion - I will try this one out! Just wanted to make sure I wasn't missing something completely 😀

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

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