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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Username() and UserPrincipalName() returning an error for some users

I have an Azure SSAS taular model deployed maing use of UserPrincipalName() function for its security model.

For some users, this has been causing problems, so I created two measures in the tabular model to get the root of the issue;

whoami:= Username()

whoami2:=UserPrincipalName()

I deployed the model and published a Power BI app with a report containing both measures in two separate visuals.

For a certain user, this creates an error (at the bottom of this post).

However, when I do the same process but in a Power BI dataset, the measures work fine.

What is the cause of the error in the context of the Azure SSAS tabular model?

success.png

failure.png

 

 

Fields that need to be fixed
Something's wrong with one or more fields: (Unified Security) whoami
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 605969cf-cfba-41bc-9d53-8af4b8795703
Request ID: 5c1d4494-edee-d9eb-88b9-78468134b6b7
Correlation ID: f76926a6-8085-6ef0-2a2e-d384916f12e2
Time: Thu Sep 26 2019 13:51:59 GMT+0100 (GMT Summer Time)
Version: 13.0.10805.184
Cluster URI: https://wabi-europe-north-b-redirect.analysis.windows.net

1 REPLY 1
v-lid-msft
Community Support
Community Support

Hi @Anonymous ,

 

For the issue, I cannot reproduce it here. We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/

 

BTW, We suggest you to delete the ID and URL in this forum.

 

Support Ticket (1).gif

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors