Forum Discussion

PGhosh's avatar
PGhosh
Frequent Visitor
4 years ago

Unable to test RLS 'Test as Role' for external users in Power BI service

Hi everyone,  I used to test Row level security in Power BI service using "Test as role" feature under Security. However, now it has stopped working using standard email address format.  We are sto...
Need Help
PGhosh's avatar
PGhosh
Frequent Visitor
4 years ago

hi v-henryk-mstf  

Thanks for your response. I am using USERPRINCIPALNAME() for RLS. 

My Question is different – If I am storing email ID’s in standard format ( Without #EXT#) I am unable to Test security in Power BI service ( Via – Test as role).

Now to test security of my dataset in Power BI service, I have to store the email format, eg.  xyz.bodo_businessmail.com#EXT#@companyname.onmicrosoft.com in RLS table.

I never had to do this before. 

Now when I am testing RLS, it always shows blank charts in PBI Service. I tested it for the external users you can access this report fine and see their data on our tenant. Screenshot below. 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi PGhosh,

Did you solve this one?

Because we are experiencing the same thing. We cannot test as role unless we add the email format with #EXT#.

  • PGhosh's avatar
    PGhosh
    Frequent Visitor
    4 years ago

    Hi Anonymous - No the issue is not solved yet. I am not really sure who accepted v-henryk-mstf response as a solution. 

    I did respond to v-henryk-mstf's response with more information and screenshots but havent heard back. 
    This issue still persists and so far I have not found any solution. 

    Thanks! 

    • Mattiar's avatar
      Mattiar
      Resolver I
      11 months ago

      The problem still persists. Unfortunately no one from Microsoft confirms the problem, but if after 3 years the problem has remained, then it means that it cannot be tested.