Solved: RLS roles in embedded report stopped working

Anonymous · ‎12-17-2021

Hi,

I have created an embedded report that includes a language role and a company role. There hasn't been any changes in the roles yet suddenly the report started to send an error message complaining about the relationships. The incident is appearing only in the embedded version - in desktop mode the roles are still working without any problems.

I already tried changing the relationships from both to single but the error keeps coming.

I'm very grateful for any tips!

Julia

andygash · ‎12-21-2021

I have experienced this issue as well. Our users with multiple roles were able to access the data on Thursday, Dec. 16, and on Friday, Dec. 17, many tables were blanked out with the error message and the circled-x in the middle of the data table. This occurred only with those that had been assigned multiple roles. Those users with one role had no issues. We've had no change in the relationships between tables for months and no problem with our multiple role users, until now. There is no time stamp on the automatic updates, but I'm betting that the Dec, 2021 roll out occured on Dec. 16. At least all our reviews point to a Microsoft problem and these posts validate that as well. Please let us know when a solution is available. We have implemented work arounds, however, the product (Power BI) is malfunctioning and these work arounds are unsustainable for such a vaunted platform as Power BI.
Thank you.

View solution in original post

canastasi__panl · ‎12-20-2021

@AnonymousI have come to say that I am experiencing the same issue that you have reported. At the same time as you, my reports return the same error when users are members of two roles. No changes have been made to the dataset recently.

andygash · ‎12-21-2021

I have experienced this issue as well. Our users with multiple roles were able to access the data on Thursday, Dec. 16, and on Friday, Dec. 17, many tables were blanked out with the error message and the circled-x in the middle of the data table. This occurred only with those that had been assigned multiple roles. Those users with one role had no issues. We've had no change in the relationships between tables for months and no problem with our multiple role users, until now. There is no time stamp on the automatic updates, but I'm betting that the Dec, 2021 roll out occured on Dec. 16. At least all our reviews point to a Microsoft problem and these posts validate that as well. Please let us know when a solution is available. We have implemented work arounds, however, the product (Power BI) is malfunctioning and these work arounds are unsustainable for such a vaunted platform as Power BI.
Thank you.

Anonymous · ‎12-19-2021

Hi @Anonymous,

Can you please share more detailed information to help us clarify your scenario? (e.g. data source type, RLS expression, role settings and embedded configurations, relationship type[one: one, one to many, many to many]...) It should help us clarify your question and test to troubleshooting.

How to Get Your Question Answered Quickly

In addition, you can also take a look at the following link about power bi embedded with RLS usages if helps:

Using row-level security with embedded content in Power BI embedded analytics - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng