Forum Discussion

ptmuldoon's avatar
ptmuldoon
Icon for Resolver I rankResolver I
1 year ago

RLS not working with UPN?

I struggling to understand why what I think is a basic RLS role is not returning the correct user.   I've create a Gen2 Flow that imports a user table that includes their email address.   I've adde...
Need Help
Poojara_D12's avatar
Poojara_D12
Icon for Super User rankSuper User
1 year ago

Hi ptmuldoon 

 

  • Check USERPRINCIPALNAME() : It returns the logged-in user's email/UPN. Ensure it matches your login in Power BI Service.

  • Test in Service: Publish the report and confirm you're logged in with the correct email.

  • Verify Role Assignment: Confirm your email or group is correctly assigned to the role in the dataset’s Security settings.

  • Debug Output: Add a measure to check what USERPRINCIPALNAME() is returning:

 

CurrentUser = USERPRINCIPALNAME()

 

  • Match Email Format: Ensure EMAIL in your Users table matches the format of USERPRINCIPALNAME() (e.g., [email protected]).

  • Avoid Multiple Accounts: Ensure you're logged in with the intended account; clear browser cookies or use incognito mode if needed.

  • Group Membership: If using a group, verify your email is part of it in Azure AD.

  • Service Caching: Refresh the dataset if changes were recently made.

 

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS