Тёмный

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

SQLBI
Подписаться 107 тыс.
Просмотров 8 тыс.
50% 1

Опубликовано:

 

7 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 13   
@IconicLemon
@IconicLemon Год назад
Great video thanks, @ 1:31, you have blurred out UserObjectID but when you have hovered the mouse over the output you can see the full string.
@SQLBI
@SQLBI Год назад
Thanks for reporting it! The value is a local ID so it's not really important, so we decided it was not worth the remaster the video (which would lose the original link). Thanks again!
@rvgfox
@rvgfox Год назад
Great Alberto ! Is it possible to use the CUSTOMDATA in the connection string in one query in Power Query?
@SANJIVRAI6693
@SANJIVRAI6693 Год назад
Is there any way to get the domain "SNOW" from the username in Services (Publish version)
@SQLBI
@SQLBI Год назад
Services uses AD username, not the domain.
@comptegmail273
@comptegmail273 Год назад
do you know how can I retrieve the user's microsoft account profile picture ?
@SQLBI
@SQLBI Год назад
Probably through this API, certainly not in DAX! learn.microsoft.com/en-us/graph/api/profilephoto-get?view=graph-rest-1.0
@comptegmail273
@comptegmail273 Год назад
@@SQLBI I will look through that thank you
@1yyymmmddd
@1yyymmmddd Год назад
It looks like USERNAME() although works fine in Desktop, is not working in the Service :)
@SQLBI
@SQLBI Год назад
It should work - it is designed for the Service!
@1yyymmmddd
@1yyymmmddd Год назад
@@SQLBI It does not display USERNAME() value in a card. Shows Error in Service, although in Desktop it displays correct value. However it turns out that it returns domain\username in Desktop and user email address in Service.
@SQLBI
@SQLBI Год назад
You are probably making some other mistake - it works correctly also in the service in a card. Open a ticket with Microsoft support to further investigate what is not working on your tenant.
@nishanththulasiram5851
@nishanththulasiram5851 7 месяцев назад
Hi sir, how to retrieve user id in power bi service, as username function returns email id and not user id.
Далее
Differences between GROUPBY and SUMMARIZE
28:30
Просмотров 37 тыс.
The Most Elite Chefs Ever!
00:35
Просмотров 3,4 млн
Прохожу маску ЭМОЦИИ🙀 #юмор
00:59
Solving errors in CALCULATE filter arguments
30:55
Просмотров 28 тыс.
Introducing window functions in DAX
40:58
Просмотров 42 тыс.
Using RELATED and RELATEDTABLE in DAX
18:04
Просмотров 39 тыс.