Forum Discussion

aktripathi2506's avatar
aktripathi2506
Icon for Helper IV rankHelper IV
10 years ago

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...
Need Help
KGrice's avatar
KGrice
Icon for Memorable Member rankMemorable Member
10 years ago

Maybe your date column in Excel is formatted like a date, but isn't really a date? If it's text that looks like a date you and I can recognize, but isn't really a date that Excel/Power BI recognize as a date, that could be it. What happens when you change the format in Excel to General? If it's really a date, the cell should now show a number.

 

If that doesn't help, can you provide a screenshot of the data you have in Excel?