Prevent PowerBI from automatically adjusting for day light saving

[vpatel55]

I'm importing documents from Cosmos DB contaning datetime in UTC. However, when I change the format to "DateTime" in Power Query, it is adding an hour. I'm presuming that it is tyring to be helping to adjust for daylight saving, but this is not wanted.

The odd thing is that I have an earlier version of this file open, and when I change to DateTime, it does not convert. The M code in both cases is identical.

It seems that using the option "Date/Time/Timezone" does not adjust automatically, but I don't know how this will behave when the clocks change again. So I only want to work in the format of the raw data, which is UTC.

--> How do I select DateTime format without it automatically adjusting?

Thank you.

[vpatel55]

This is just to mark the topic as without an answer, in case anyone else finds this. For reasons unclear, Power BI keeps shifting times. The behavior is entirely random, and there is no way to predict when this will happen.

[vpatel55]

Hi @amitchandak , thanks so much for your response. I'm afraid these solutions will still require me to write code to deal with the issue.

What I have done instead is downloaded a backup version of my PBI file before my change, as this does not suffer from the same problem - despite the M code being the same.

[amitchandak]

@vpatel55 , refer if the old solution can help

https://community.powerbi.com/t5/Desktop/Day-Light-Saving-Time-affecting-visualization/m-p/560514