OLE DB or ODBC error: DataFormat.Error

[Anonymous]

I have one excel file per each month of the year and I having problem loading the data into the power bi.

My worksheet have different values types like text, whole number, decimal number, hours and date. I think the error comes from the data format but I already removed the errors but when I try to load the data again the same error appears.

[Anonymous]

For your description, it sounds like there is some non-numeric data in some of the rows that you were previously converting to number. The problematic cells may be beyond the first chunk of rows PQ displays in the preview, but are likely being encountered when doing the filter.

I'd recommend you examine the source data to determine where the errors are coming from, remove or fix up the problematic rows, and then re-apply the number conversion.

[Anonymous]

Hi @Anonymous,

Whether the issue in below screenshot has been resolved?

Best Regards

Rena

[Anonymous]

Hi @Anonymous ,

It seems some date columns in your excel sheet cannot be converted to Date format correctly when load data into Power BI Desktop..

First , please check if the format of each data column in your excel sheet is correct or not(like if contains any space or special character in date column).

Also , could you please provide some sample data(exclude sensitive data)? And please provide the locale of your Power BI Desktop by the following steps :

1 . Open Power BI desktop

2 . Click File->Options and Settings->Options

3 . CURRENT FILE-->Regional Settings

 

Best Regards

Rena