Imported date is 1 day out daylight saving

[Hepworthnot]

Hi,

I have seen many threads on this problem but nothing I have tried has worked.

I am trying a solution of adding one hour to the time in SharePoint before importing to Power BI. This gives the correct date but unfortunatelty Power BI imports it as text in this format:

2022-11-25T01:00:00Z

I have tried converting this data type to date or date and time but I get an error message saying it is not possible.

Does anyone know how I can get Power BI to import it as a date or convert it from text.

Thank you.

Phil

[v-stephen-msft · Accepted solution]

Hi @Hepworthnot ,

Have you tried to change type with using local?

Change the data type to date or date/time type, and then in the Locale, select the region where the date format you imported is the same. Below are sample input values for your reference.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.