The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to 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.
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.
Thank you, that was it. It is working now.
Thank you, that was it. It is working now.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
31 | |
25 | |
23 | |
22 |
User | Count |
---|---|
64 | |
62 | |
53 | |
38 | |
34 |