Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hi everyone -
I recently made a switch to the way we create RLS roles & assign access by taking advantage of the USERPRINCIPALNAME() function and having an Excel file on SharePoint where we add new users.
It works perfectly when I tested it using internal users. But as soon as I add external users to the roles under the "Security" page on Service, I am unable to access the "Security" page again and receive the error message below.
I published the PBIX file under different names and tested it again and again, and the same things happens - as soon as an external guest is added, I receive the error message above.
Is there something I am doing wrong? Any help would be appreciated 🙂
Solved! Go to Solution.
Hi, @bheepatel
Have submited this issue internal to confirm(ICM:277255370). This issue has been fixed.
Issue_Desc
Power BI users trying to access the ‘Security’ settings of dataset may see a blank page which will prevent them from accessing\Modifying RLS.
Workaround
Publish the report as a new copy and recreate roles.
You can test to see if the problem is fixed. If there are still problems, please contact us promptly.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @bheepatel
Dynamic RLS works with both internal or guest users.
You need to invite external users as guest users first. You need to invite external users as guest users first. Invitation methods are planned invites and ad hoc invites. Please refer to the following documents for details on how to operate: Distribute content to external guest users with Azure AD B2B - Power BI | Microsoft Docs
The next question is how dynamic row level security (RLS) work with Azure AD B2B. Please refer to the following documents: Distribute Power BI content to external guest users using Azure Active Directory B2B - Power BI | Mi...
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-zhangti
The issue is that I am unable to open the "Security" tab when adding users to the roles I created.
The articles above do not help me - I have already followed all those steps and external users have been added to Azure AD.
Hi, @bheepatel
Have submited this issue internal to confirm(ICM:277255370). This issue has been fixed.
Issue_Desc
Power BI users trying to access the ‘Security’ settings of dataset may see a blank page which will prevent them from accessing\Modifying RLS.
Workaround
Publish the report as a new copy and recreate roles.
You can test to see if the problem is fixed. If there are still problems, please contact us promptly.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @bheepatel
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Hi, @bheepatel
Have you tried deleting the report and republishing it? Or try publishing the report in another workspace.
I saw another post with a similar situation to yours, and I hope it helps.
https://community.powerbi.com/t5/Service/Power-BI-Service-unable-to-load-RLS-Roles/td-p/2240495
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
35 | |
32 | |
21 | |
11 | |
8 |
User | Count |
---|---|
54 | |
43 | |
28 | |
13 | |
11 |