Query editor load error

[stanislav_dugas]

I have a 2 dataset that i merged in query editor and performed several adjustments. After I go close and apply during the load i get an error.

"1st data table

OLE DB or ODBC error: (DataFormat.Error) We couldn't convert to Number..

2nd data table

Load was cancelled by an error in loading a previous table"

I checked for errors in both tables and i couldnt find any it shows 100% valid in all columns.

Any help on what to do is highly appreciated.

Thanks guys.

[v-alq-msft · Accepted solution]

Hi, @stanislav_dugas 

Please check if each column has the corresponding correct data type. Here is an example.

When the data type is mismatched, the error happens.

After modify the data type as the correct one, the error disappears.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@stanislav_dugas , Open Data Data Transformation. You will see s detailed error there in yellow, Check the columns of the table you should see some error.

seem like there is space or - in number column. if you are taking data from excel or csv check the file.