cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AmeyaDingre
Helper I
Helper I

RLS can be applied with power BI report server

Hi,

 

Is it possible to apply RLS on Power BI report server?

 

If Yes, request you to explian the steps.

 

Regards,

Ameya

3 REPLIES 3
v-yulgu-msft
Microsoft
Microsoft

Hi @AmeyaDingre,

 

Currently, RLS only works when publishing Power BI reports to service, as we need to add members to roles on service site. Power BI Report Server doesn't support this feature. 

 

However, if your data source supports RLS, you can configure RLS on data source side. After publishing report to Power BI report server, set the data source credential to "As the user viewing the report". Here is a similar thread for your reference.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
otravers
Continued Contributor
Continued Contributor

May I suggest you mention this on the RLS documentation? PBI RS is nowhere to be seen there:

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/

 

And the PBI RS version of PBI Desktop does have the Security > Manage / View Roles buttons, which do work (I just tested it in PBI RS Desktop August Preview). Does this mean RLS will be supported in the Q4 GA release? It's a bit cumbersome to have to manage RLS in the SQL source (and at least we have that option, it's not the case for all data sources).

ryan-gao
Helper III
Helper III

same question

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!

Top Solution Authors