Error in test as Role RLS Power BI Service

[Anonymous]

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 USERPRINCIPALNAME().

Also, how does 'Test as Role' option differ in PBI service & PBI Desktop? Does PBI Desktop also fetch UPN from AAD?

Any help is greatly appreciated.

[Anonymous]

Hi @Anonymous 
Any updates on this? I issue still persists.

[Anonymous]

Hi @Anonymous ,

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 

Best Regards,

Jay

[Anonymous]

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.