Dynamic RLS

[RGNdq_2022]

Hi,

I have used a model (Users and Roles) for a dynamic RLS implementation. I use the DAX method USERPRINCIPALNAME() to get the logged in user and the relationship that I have defined does the rest. When I use the View as option on the Power BI Desktop, it filters and shows the data correctly. 

When I publish onto the Power BI Service and login as a user ( this user is set with Viewer permissions), I get the following error message:

Unable to load the model

Please try again later or contact support. If you contact support, please provide these details.See details Activity ID: 9a1f9bab-0260-43e7-8fcc-37a80504d83a
Request ID: 4e93e92d-ab78-5095-105f-5cb353385807
Correlation ID: 60a89c7e-f865-a702-fa44-e3803ab4aff6
Time: Fri Jun 03 2022 13:06:16 GMT-0400 (Eastern Daylight Time)
Service version: 13.0.18354.31
Client version: 2205.4.11469-train

[v-eqin-msft · Accepted solution]

Hi @RGNdq_2022 ,

If you have configured dynamic RLS, and wanted to restrict data access for user A, such error usually occurs when user A has permissions of dataset but is not assigned RLS roles.

Refer to:

When Something Goes Wrong (Unable to Load the Model) – Prologika

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

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

[v-eqin-msft · Accepted solution]

Hi @RGNdq_2022 ,

If you have configured dynamic RLS, and wanted to restrict data access for user A, such error usually occurs when user A has permissions of dataset but is not assigned RLS roles.

Refer to:

When Something Goes Wrong (Unable to Load the Model) – Prologika

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

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

[RGNdq_2022]

Thank you, that was it. It is working now.

[RGNdq_2022 · Accepted solution]

Thank you, that was it. It is working now.