Report Viewer Error - "Something Went Wrong"

[BILearner11]

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

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

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

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

[v-henryk-mstf · Accepted solution]

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.

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.