Forum Discussion

DaleH's avatar
DaleH
Icon for Resolver I rankResolver I
2 years ago

RLS with External User. Works when they sign in. Shows no data when I test as role. UPN fails.

We share reports with external users.  They are invited to our tenant, have a Power BI Pro license and viewer authority. We use an app to provide them access to the reports. We are using RLS based ...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
2 years ago

Hi DaleH 

I have found it easiest to create a report where you can see the list of external users in a slicer. Then when you click on the user in the slicer it will work as it would when the user logs in.

 

This works well for me.

DaleH's avatar
DaleH
Icon for Resolver I rankResolver I
2 years ago

GilbertQ This is an alternative, but, it does not quite check all the boxes.  Certain users have elevates privlidges and can see reports others cannot.  Thank you for the idea, it will be useful.

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    2 years ago

    Hi DaleH 

     

    I have tested it this way successfully and it works well to determine if the RLS is working as expected.