Skip to main content

Power BI

New

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

408295f3 4d7f-4110-9b30-9926c34e4298 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

ab372c08 03f5-46f0-8d34-06d8d9f22605 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

440eae72 caa2-e611-80f7-5065f38a4951 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

408295f3 4d7f-4110-9b30-9926c34e4298 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

02c463c0 4e88-4a98-9c7e-857637678e59 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

8853be90 dd17-4aea-a898-6838c5647311 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

8853be90 dd17-4aea-a898-6838c5647311 on 05 Jul 2020 22:17:52

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

This will be very useful