Keep UTC 00:00 in time stamp

[kadapavel]

Hello,

Please support and possibly advise solution..

My sensor data timestamps are stored in database in UTC 00:00, when I download it and process outside power bi(i process the data with R script) results are linked to time stamp 00:00.

Then I upload it to Power bi where timestamp is converted to my local time stamp but results are linked to UTC 00:00, as a resut is mess up charts and conclusions.

Is there a way to keep Power bi time setting so that timestams are not converted to local time?

BR

[MarcelBeug · Accepted solution]

Based on your limited information: your input should be imported as datetimezone values. Instead of converting to type datetime, you can use function DateTimeZone.RemoveZone, which will cut off the time zone without converting the times to your local time.

Alternatively you can keep the values as datetimezone values in the Query Editor, as the zone will be cut off anyhow when loading into the datamodel.

Illustrative query: the first 2 columns will load as UTC, the third will load in your local date/time.

let
    Source = #table(type table[DTZ = datetimezone],{{#datetimezone(2017,12,5,11,53,0,0,0)}}),
    #"Added Custom" = Table.AddColumn(Source, "DT UTC", each DateTimeZone.RemoveZone([DTZ]), type datetime),
    #"Duplicated Column" = Table.DuplicateColumn(#"Added Custom", "DTZ", "DT Converted"),
    #"Changed Type" = Table.TransformColumnTypes(#"Duplicated Column",{{"DT Converted", type datetime}})
in
    #"Changed Type"