Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dynamic RLS Working as a Test Role in Power BI Service but it is blank when shared with same Users

Dear Power BI Community,   I am a facing a weird problem with Power BI Service I have successfully implemented Dynamic RLS in Power BI Desktop and also it is working fine when I test it as a role i...
Need Help
v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Anonymous 

 

Guest user: [email protected]

Whether the value in the table is abc_domainName.com#EXT#@ourOrganization.onmicrosoft.com data.

[email protected] , only data that belongs to the rows fully matched with this value will be displayed for him,  If there is a row whose value is abc_domainName.com#EXT#@ourOrganization.onmicrosoft.com, it won’t be displayed for the user  [email protected]

So, guest users email for [email protected], not abc_domainName.com #EXT#@ourOrganization.onmicrosoft.com then you could take it as UPN.

 

For reference:

Solved: RLS for External guest users - Microsoft Power BI Community

 

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for your response. I have tested both in my case but both tend to fail when I choose the email of the format [email protected]even the test fail at Power BI Service and also the guest users receive blank report. When I use email of the format abc_domainName.com#EXT#@ourOrganization.onmicrosoft.com Power BI Service when I test as a role test is successful but when I share the report with same users report is blank. So both tests fail ultimately for me. Any thoughts or suggestions to resolve this problem?

     

    Kind Regards,

    Fassahat