Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
RGNdq_2022
Frequent Visitor

Dynamic RLS

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
2 ACCEPTED SOLUTIONS
v-eqin-msft
Community Support
Community Support

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.

Eyelyn9_1-1654501387042.pngEyelyn9_2-1654501437205.png

 

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

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

View solution in original post

3 REPLIES 3
v-eqin-msft
Community Support
Community Support

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.

Eyelyn9_1-1654501387042.pngEyelyn9_2-1654501437205.png

 

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.

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

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors