Solved: Dynamic RLS

RGNdq_2022 · ‎06-03-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

Anonymous · ‎06-06-2022

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.

View solution in original post

RGNdq_2022 · ‎06-06-2022

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