Forum Discussion

Macc-PA's avatar
Macc-PA
Helper I
4 years ago

How to remove timezone

Hi, I get my data from an odata feed where the dates come down in UTC plus an offset which includes daylight saving, E.g 21/05/2022 00:00:00 +1 for a date in the UK timezone with daylight saving. H...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Macc-PA ,

 

Not very clear about the situation.

You may try disabling the auto-date-time feature and check again.

If it doesn't work, you may take a look at these topics.

https://community.powerbi.com/t5/Power-Query/Convert-Date-Time-in-UTC-to-Local-Time-with-Daylight-savings/td-p/789919 

https://community.powerbi.com/t5/Service/Handling-local-time-zone-with-Daylight-Savings-in-Power-BI/m-p/991812 

Or share some sample data and expected result here.

 

Best Regards,

Jay