Error in test as Role RLS Power BI Service

Question

Hello,For last few weeks, I have been getting an error in Power BI service when I try to use the Test as Role.It works fine for internal (same domain users) but it shows no data for all external users.Also note that All externals users are also added in AAD.I have verified that RLS is setup properly. RLS uses&nbsp;USERPRINCIPALNAME().&nbsp;Also, how does 'Test as Role' option differ in PBI service &amp; PBI Desktop? Does PBI Desktop also fetch UPN from AAD?Any help is greatly appreciated.

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
You would first need to add the external user as part of your AAD, and then assign them access to your dataset, by going into the dataset settings and then clicking on Security.
Here are more details on how to do this. Scroll down to the section, which will explain how to achieve this.
https://docs.microsoft.com/en-us/power-bi/guidance/whitepaper-azure-b2b-power-bi#data-security-for-external-partners&nbsp;
&nbsp;
Best Regards,
Jay

anonymous · Answer

Hello,Thanks for your reply. I have followed the same steps as mentioned in the same chronological order. Still the issue persists. I am able to add in dataset/Security means user was correctly added in AAD too.

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;Any updates on this? I issue still persists.

Forum Discussion

Error in test as Role RLS Power BI Service

3 Replies

Related content

Power BI Service error

Refresh Error in power bi services

Error Power BI Service - Need Help Please!

Power bi service

Power BI Service Mashup Data Access Error