topic Re: Return username in report instead of email address in Power BI Report Server in Report Server

Return username in report instead of email address in Power BI Report Server

mdubose — Tue, 07 Feb 2023 19:18:13 GMT

Hello,

I'm using the DAX function, username() in a Row-Level Security role. In Power BI Desktop, this functions returns the username in this format: domain\user which is expected. However, when I publish the report to Report Server, this function returns the user's email address.

How can I return the username in this format domain\user?

Re: Return username in report instead of email address in Power BI Report Server

freginier — Tue, 07 Feb 2023 19:50:18 GMT

What do you have using UserPrincipalName() ?

https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

Re: Return username in report instead of email address in Power BI Report Server

mdubose — Tue, 07 Feb 2023 19:53:09 GMT

Hi @freginier ,

With UserPrincipalName() , I also get the email address which I believe is expected. However, I do not want to return the email address of a user but their username instead. A user's username is going against my dataset. Email address is not.

Re: Return username in report instead of email address in Power BI Report Server

d_gosbell — Wed, 08 Feb 2023 03:51:52 GMT

Are you sure you are deploying to an on-prem report server?

As noted in the example here USERNAME - DAX Guide

USERNAME() should return the name in domain\user format unless you are quering AzureAS or the Power BI Service in which case it returns the same value as USERPRINCIPALNAME() (which is an email address format)

Re: Return username in report instead of email address in Power BI Report Server

mdubose — Wed, 08 Feb 2023 14:58:59 GMT

Hi @d_gosbell ,

I'm sure I'm deploying to Report Server. See image below. Also, authentication in through an on premise Active Directory. Is there any setting in a config file on Report Server in which needs to be changed to make this work?

Re: Return username in report instead of email address in Power BI Report Server

d_gosbell — Wed, 08 Feb 2023 23:16:56 GMT

I'm not aware of any config setting that would change this. I've never seen this behaviour before.

This might be some AD configuration. When you look in the top right corner of the report portal what format is the username there? Is it domain\user or user@domain ? You might need to open a support ticket with Microsoft to get help on this.

Re: Return username in report instead of email address in Power BI Report Server

mdubose — Thu, 09 Feb 2023 02:21:09 GMT

It displays the user's name. For example, John Doe.

Re: Return username in report instead of email address in Power BI Report Server

mdubose — Mon, 06 Mar 2023 19:31:42 GMT

I've created a support ticket with Microsoft and they've informed me that this is an expected behavior. In that, the USERNAME() dax funtion returns UPN instead of domain\user format when report is published to Power BI Report Server.

Re: Return username in report instead of email address in Power BI Report Server

Simhalauday — Fri, 28 Mar 2025 09:01:34 GMT

@mdubose are you able to pull the username? Even I got the same scenario if you find the solution please share.