PBI Reading Date Incorrectly

[Anonymous]

My data source is Excel files which worked fine for previous files. 

I checked the source file and it is formatted exactly the way the previous files are.

This is not isolated to this specific row as there are many such issues with other rows.

[v-gizhi-msft]

Hi,

You can try to define date format in Power Query.

Could you please share your query in Query Editor as screenshots?

Best Regards,

Giotto