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

RLS doesn't work in the Report Server

Hello,

I am facing a problem with RLS and I deeply need support, 

In July 2020, we have built a report containing RLS, we have saved it in the Report Server, tested it with colleagues and everything worked perfectly.

Unfortunately, now it doesn't work anymore in the report server. However in the Power BI desktop when I test with view as, everything works fine. For example,  I set myself as Manger. However, when I affect myself to the Manager role in the report server, I don't see any team. (Please be advised that it's the same report and it  worked before on the report server)

Does this have anything to do with the Power BI Report Server version,? now we are using Microsoft Power BI Report Server - January 2021 version.

I look forward to your support,

Best Regards,

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@imenmaiza 

 

The version should not be the cause, RLS worked fine in my Jan version. Did you change any data in the datasource? Please try re-save the new pbix to Report Sever and test again.

 

Here are the limitations:
Row-level security (RLS) in Power BI Report Server - Power BI | Microsoft Docs

 


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
V-pazhen-msft
Community Support
Community Support

@imenmaiza 

 

The version should not be the cause, RLS worked fine in my Jan version. Did you change any data in the datasource? Please try re-save the new pbix to Report Sever and test again.

 

Here are the limitations:
Row-level security (RLS) in Power BI Report Server - Power BI | Microsoft Docs

 


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hello @V-pazhen-msft,

I rechecked and it was a mistake in the Emails.

Thank you for your support, I wanted to make sure if it was related to Power BI version.

Best Regards, 

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!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

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