Skip to main content
Microsoft Idea

Power BI

Needs Votes

Power BI Service return effective user name for username () DAX

Vote (54) Share
Jason Davenport's profile image

Jason Davenport on 22 Oct 2015 06:17:09

Would be helpful if username () or customdata () DAX command would return effective username logged into the portal, could be used for quick filtering based on the login for data that is uploaded from PowerBI

Comments (7)
Jason Davenport's profile image Profile Picture

ste Power BI User on 05 Jul 2020 22:23:16

RE: Power BI Service return effective user name for username () DAX

User name now works to return email : https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/

Jason Davenport's profile image Profile Picture

Richard on 05 Jul 2020 22:22:12

RE: Power BI Service return effective user name for username () DAX

I see the CustomData property is now active. Is there documentation around this implementation?

We need it returning the email address of the user, even though they are querying a SSAS Live Database. Does it mean we get remove On-Premise AD authentication?

Jason Davenport's profile image Profile Picture

ERIC BLANCHE on 05 Jul 2020 22:20:05

RE: Power BI Service return effective user name for username () DAX

I agree, we need it for using powerBI with CRM.

Jason Davenport's profile image Profile Picture

ste Power BI User on 05 Jul 2020 22:19:21

RE: Power BI Service return effective user name for username () DAX

We have the same requirements to filter report data base on current logged on user, being able to use username () dax function with the new Row -Level Security in Preview (https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/#limitations ), would be ideal.

Jason Davenport's profile image Profile Picture

Power BI User on 05 Jul 2020 22:17:57

RE: Power BI Service return effective user name for username () DAX

we have a requirement to break out report data to individuals, the data is provided from a database using such an approach and then measures/filters would enable a single report/dashboard to be shared across multiple users from a single source removing DPA issues.

Jason Davenport's profile image Profile Picture

Sarva on 05 Jul 2020 22:17:52

RE: Power BI Service return effective user name for username () DAX

This will be very useful.

Jason Davenport's profile image Profile Picture

Sarva on 05 Jul 2020 22:17:52

RE: Power BI Service return effective user name for username () DAX

This will be very useful