Forum Discussion

MadisMerk's avatar
MadisMerk
Helper I
7 years ago

DataFormat.Error: We couldn't parse the input provided as a Date value

Hi,

 

I am importing a table to Power BI desktop from an Excel file

 

And for some reason I am getting an error like this:

 

DataFormat.Error: We couldn't parse the input provided as a Date value.
Details:
B.2007.46.006

 

Why is the system even trying to treat that read cell as a date? And the strangest thing is that the error pops up after I have totally removed that column from the table.

 

I tried to change the data type to text for the column that gives the error message but it did not solve the issue.

 

Please advise!

 

Madis

Need Help

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, MadisMerk 

    I have tested on my side, it works well. You may try to change the data type to text for this column.

    Note: Must choose Replace current

     

     

    Best Regards,

    Lin