Forum Discussion
Wrong date import from excel file
Hi, The date import from excel is incorrect. For example, the dates highlighted in yellow has reverse date and month. Those date from 1 to 12 will become the month instead of the date. Eg: ...
Anonymous - you had similar issue previously and I think this was resolved here- https://community.powerbi.com/t5/Desktop/Inconsistent-Date-Format-in-excel-file/m-p/1447247#M607073
Hi amitchandak AlB ,
This is the sample data: https://we.tl/t-HgwZE11QGP
You can see the highlighted date is November dates, but after importing to Power BI, it became 11th of the month.