Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DaleH
Resolver I
Resolver I

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 on their UPN.

The external users are working as expected and can see their own data.

 

When I attempt to 'test as role' and 'Select person' using their identity, the tenant retrieves their id just fine, but, assigns them a UPN which is different:

   Actual UPN: mail#JohnDoe@contoso.com

   UPN Assigned by 'test as role' process: JohnDoe_contoso.com#EXT#@tenant.com

Because the UPN no longer matches, the RLS filters all the data and the test as role process shows empty screens.  

Do you know how I may test as role with out altering the security tables to grant to #EXT# UPN access?

Thx

 

3 REPLIES 3
GilbertQ
Super User
Super User

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@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.

Hi @DaleH 

 

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors