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 ...
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.