USERNAME, USEROBJECTID, USERPRINCIPALNAME, CUSTOMDATA, USERCULTURE - DAX Guide

Published: 12 December 2022
on channel: SQLBI
7,906
101

USERNAME: Returns the domain name and user name of the current connection with the format of domain-nameuser-name.
https://dax.guide/username/

USEROBJECTID: Returns the current user’s Object ID from Azure AD for Azure Analysis Server and the current user’s SID for on-premise Analysis Server.
https://dax.guide/userobjectid/

USERPRINCIPALNAME: Returns the user principal name.
https://dax.guide/userprincipalname/

CUSTOMDATA: Returns the value of the CustomData connection string property if defined; otherwise, BLANK().
https://dax.guide/customdata/

USERCULTURE: Returns the culture code for the user, based on their operating system or browser settings.
https://dax.guide/userculture/

This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel.

How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: https://www.sqlbi.com/books/the-defin...
Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt

#dax #powerbi #ssas #tabular #analysisservices #powerpivot


Watch video USERNAME, USEROBJECTID, USERPRINCIPALNAME, CUSTOMDATA, USERCULTURE - DAX Guide online without registration, duration hours minute second in high quality. This video was added by user SQLBI 12 December 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7,906 once and liked it 101 people.