Forum Discussion
Change UTC Timezone to Local Time in Directquery Mode based on the User
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!
5 Replies
CoreyPSolution Sage
How are you determining the user's location and timezone?
- CoreyP
Power BI can't determine the viewers' location/timezone.
- 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.
v-zhangtiCommunity Support
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 CommunitySolved: 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.
