Forum Discussion
Error with importing date columns
Hi, This is a very common error I am getting everytime. I am importing data from excel to power BI. WHenever excel has a date column it gives the error in power BI query mode. When I click on th...
Hi aktripathi2506,
Glad to hear that the issue is resolved.
Based on my test, when using Power BI Desktop to conenct to .xlsb file, something doesn't work as expected such as Date. Currently, we can use Power BI Desktop(32bit and 64 bit) to connect to .XLS, .XLSX and .XLSM files.
Thanks,
Lydia Zhang
I was having the same problem - Excel file has whole date column formatted date mm/dd/yy, but importing to Power BI only resulted in non-date format you'd experienced. What fixed this for me was converting the file from .xls to .xlsx... not sure why it made the difference, but importing into PBI now automatically has the correct date format without any need for intervention. Just thought I'd share in case it can help others!