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...
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?
HI,
No I checked it, the data type was date only. When I change it to text I get numbers.
I tried something random and it worked for now but I am not sure if this is a permanent solution. I selected the entire column with header and change the data type to date and then it worked.
