How to display date time with time zone in power bi report

[balajiratnala6]

I need to show date time with time zone in report  as 12/09/2022 15:31:44 UTC

Please help me to achieve it.

[balajiratnala6]

I have solved this problem through SQL query as we using  Power BI Desktop Advanced options's SQL statement and Power BI parameter to change time zone dynamically based on customer time zone.

We maintaining default UTC time zone in our back-end APP.

executionDate field from DB is only Datetime, not included timezone but have to show zone on report So implemented this flow.

select  executionDate  at time zone 'UTC' at time zone '"&setTimeZone&"' from TABLE

Through parameter we replacing setTimeZone and selected parameter zone displayin on report using measure as below

Thank you all for your replies.

[balajiratnala6]

We have to show different timezones based on customer timezone on report.

[lbendlin · Accepted solution]

Power BI does that for you automatically, based on the users'  browser settings.

https://radacad.com/solving-dax-time-zone-issue-in-power-bi

[castor]

THat's not a solution. And your answer is false . power bi doest not automatically (not natively) handles timezone based on browser settings. The link that you point to has 3 different static alternatives to convert timestamps more or less dynamically, but it has to be coded in dax or power query, so "automatically" is not the right word.

[lbendlin]

Power BI service works on UTC, so you get that for free.  You can also take a UTC datetimezone vaule, remove the timezone in Power Query, and then display the DateTime value with a label that states that the data is showing in UTC.