cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BILearner11
Regular Visitor

Report Viewer Error - "Something Went Wrong"

A report with role level security role setting is published to Power BI Service. There is a column "email address" in the dataset. The RLS setting is as below. Supposedly report user can view the corresponding data/figrues based on their login email address.

 

RLS setting

BILearner11_0-1637915900526.png

 

Permission "Read" (report level) is granted to the report user

BILearner11_1-1637916212693.png

 

When report user open the report, he/she gets below error

BILearner11_2-1637916314181.png

 

Is there any clear solution we can exactly solve this problem? Our purpose is to let users view our report content based on their login email address.

 

I know other users posted similar issues before, but it seems there are not clear solution for problem like this.

 

Thank you

 

 

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Hi @BILearner11 ,

 

Based on the information you provided, it seems that you have not configured the full dynamically RLS, in Desktop you have used USERPRINCIPALNAME() in the filter condition. This function returns the name of the user as their email address.
But after publishing the report to the service, you need to continue the configuration and add the email address of the user who will implement rls to the members.

vhenrykmstf_1-1638160025714.png

After completing the above steps, try again to see if it works. In addition, make sure your user does not have edit permission to this report. Otherwise, RLS will not work.

 

For more details, you can read related doucment.

Row-level security (RLS) with Power BI - Power BI | Microsoft Docs


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


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
v-henryk-mstf
Community Support
Community Support

Hi @BILearner11 ,

 

Based on the information you provided, it seems that you have not configured the full dynamically RLS, in Desktop you have used USERPRINCIPALNAME() in the filter condition. This function returns the name of the user as their email address.
But after publishing the report to the service, you need to continue the configuration and add the email address of the user who will implement rls to the members.

vhenrykmstf_1-1638160025714.png

After completing the above steps, try again to see if it works. In addition, make sure your user does not have edit permission to this report. Otherwise, RLS will not work.

 

For more details, you can read related doucment.

Row-level security (RLS) with Power BI - Power BI | Microsoft Docs


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


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
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!