Time zone being converted to local instead of UTC

[cdn4lf]

Hi All,

I have a series of json files that I am importing into PowerBi which correctly display the UTC date information, however when the data is being imported into Desktop, it appears that it is being read as the local time instead of the UTC time.

Can anyone suggest a way that doesn't involve DAX to correct this?  I already have a DAX solution but am trying to remove the need to duplicate each date/time column to adjust for this problem.

Thank you!

[v-gizhi-msft]

Hi,

Please try UTCNOW or UTCTODAY function.

Best Regards,

Giotto Zhi

[Pragati11]

Hi @cdn4lf ,

Can you refer following thread for this please:

https://community.powerbi.com/t5/Desktop/Relative-Date-in-Local-time-not-UTC/td-p/617405

If this helps please give Kudos and mark this as a Solution! 🙂

Thanks,

Pragati

[cdn4lf]

@Pragati11 

This isn't a relative date issue.  The data coming in is formatted at UTC "StartDate":"2020-09-21T22:15:00","EndDate":"2020-12-14T23:45:00", and there is no time zone information listed.

I already have the following dax code in use, however the goal is to not need it.

DateTimeZone.RemoveZone([EndDate])+ #duration(0,DateTimeZone.ZoneHours([EndDate]),0,0)

[Pragati11]

Hi @cdn4lf ,

Have you tried using the following in Edit Query: (right click on your Date column)

If this helps please give Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[cdn4lf]

@Pragati11 

Yes, that was the first thing I did.  It pulls it as local time instead of UTC.

[Pragati11]

Hi @cdn4lf ,

Can you try the following once, if it resolves your issue: (This allows us to set our date time in multiple zones)

There is a similar thread for this:

https://community.powerbi.com/t5/Desktop/How-to-keep-source-datetime/td-p/698674

If this helps please give Kudos and mark it as a Solution! 🙂

Thanks,

Pragati