RLS issue when a report is Embedded

aibarr — Mon, 30 Sep 2024 19:10:56 GMT

Hi everyone!

I'm having an issue with a PBI Embedded report with pages (sections).
We're already able to autheticate and show some reports at our front developed with React.js, but this report in particular gives me this error.

"""

Error subyacente: RLS is enabled for this model. Username is required, Empty Roles treated as full-access.
Identificador de actividad: bccd40d3-2f2f-4f2d-bdd0-070991c2ee57
Id. de correlación: 96d527a3-3a9a-47f7-a16d-30752d8f7f30
Identificador de la solicitud: 59a1eeb9-8332-4346-9b1d-786f6134f871
Hora: Mon Sep 30 2024 15:47:01 GMT-0300 (Chile Summer Time)
Versión del servicio: 13.0.24328.59
Versión del cliente: 2409.4.21074-train
URI de clúster: https://WABI-PAAS-1-SCUS-redirect.analysis.windows.net
Identificador de actividad: bccd40d3-2f2f-4f2d-bdd0-070991c2ee57
Identificador de la solicitud: 59a1eeb9-8332-4346-9b1d-786f6134f871
Hora: Mon Sep 30 2024 15:47:01 GMT-0300 (Chile Summer Time)
Versión del servicio: 13.0.24328.59
Versión del cliente: 2409.4.21074-train
URI de clúster: https://WABI-PAAS-1-SCUS-redirect.analysis.windows.net

"""

I've already verified that the model hasn't any role set.

Do you have any ideas on what could be happening?

Thanks!!

Re: RLS issue when a report is Embedded

Anonymous — Tue, 01 Oct 2024 03:00:02 GMT

Hi @aibarr ,

According your error, I think there may be set RLS for you model.

Here are some offical blogs about
1. how to configure RLS in Power BI Desktop and manage the role in Service.
2. Embed with RLS.
For reference:

Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
Security in Power BI embedded analytics - Power BI | Microsoft Learn

Using standard cloud based row-level security with embedded content in Power BI embedded analytics

How did check the rls in your model? If you are the role have permission who is higher than viewer (with edit permission like contributer/ member / admin) in your workspace, the RLS won't work, even it is configured RLS.
Please check the Semantic Model > Security and make sure whether there is a Role in it. If yes, your model should have been set RLS.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic RLS issue when a report is Embedded in Developer

RLS issue when a report is Embedded

Re: RLS issue when a report is Embedded