Pro RLS problem in data sharing

[andleebRaja]

I have this email table.

and write this dax 

Mapping =

VAR user_name = "[email protected]"

RETURN

CALCULATE(MAX('ICM_Facility'[ALFId]), FILTER('ICM_Facility', 'ICM_Facility'[email] = USERPRINCIPALNAME())  ) and then map this email table to my dataset table on the on the basis of ALFId
and then define manage role againt this email id
then i published this in myworkspace and add security in dataset setting

then i shared dataset to other members. within organization its working fine . every user with their map email receive there own data. but without organization its not working. user can see data in some table and some table have empty dataset.
i also add user in azure directory. test role working fine. plz help me in this as soon as possible.. i have pro licenese account.

[v-yueyunzh-msft · Accepted solution]

Hi , @andleebRaja 

Based on your case issue description, you seems to configure the dynamic RLS with the UPN used for the DAX expression that define the RLS roles,  the RLS tested successfully in the "Test as role" but displayed blank for the external users, right? I think the root cause for your issue reason may like this: when the external users are added to your organization as a guest user, their actual UPN that is used to access your Power BI tenant is displayed with the string "#EXT#@" in the middle like this:

So when you added them to your RLS user table with their original UPN, you can successfully test them in the "Test as role" but it displayed blank for the external users when they actually use the UPN with the string "#EXT#@" in the middle to access your Power BI tenant, so you can try add them into the workspace as a "Viewer" role and check their specific UPN to update them in the user table and make the test again, thanks in advance!

For more info about the Power BI Azure B2B, please refer to this official document link:

Distribute content to external guest users with Azure AD B2B - Power BI | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly