Change UTC Timezone to Local Time in Directquery Mode based on the User

[liefde]

Hi Team,
Need Quick Help!
We are using Azure Data Explorer (Kusto) for getting the live data in Power BI Direct Query Mode.
We just want to convert the Timezone (UTC) to Local time based upon the User's location.
Since we are using Directquery mode, we have limitation to make changes in Power Query Editor.
I can't find any Documentation/Method to achieve this in Direct Query Mode.

Can anyone please guide me to convert UTC to Local time in Direct query Mode?
Hope I get a solution soon!

[v-zhangti]

Hi, @liefde 

Please refer to the following links in the hopes of helping you.

Solved: UTC to Local as measure - Microsoft Fabric Community

Solved: Measure to Convert UTC to local time, accounting f... - Microsoft Fabric Community
Solved: Power Query - Convert UTC to User's Client Local T... - Microsoft Fabric Community

Solved: Direct Query date conversion from UTC to Local Tim... - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CoreyP]

The reason I ask is because when a report is published in PBI service, times will always be displayed in UTC. You would need to know the timezone of viewers in order to display times in the viewers' local time. You would need a lookup table with the viewers' e-mail in one column, and another column with their timezone, or preferably a +/- value v. UTC to indicate their timezone. Then you could write a measure with USERPRINCIPALNAME() and this lookup table to do a DATEADD on the UTC time to convert it to the viewers' local.

[CoreyP]

How are you determining the user's location and timezone?

[liefde]

@CoreyP  I didn't determine the user's location and timezone anywhere.
We don't have permission to view the User's List. And also the User's Information was maintained in Azure (only for Admin).
So is that possible to convert that UTC Timezone to User Login Timezone?

[CoreyP]

Power BI can't determine the viewers' location/timezone.