Forum Discussion
Appending query: OLE DB or ODBC error: [DataFormat.Error] Unspecified error
Hi swise001 ,
Thanks for the reply!
I recreated the model, placed all files locally but the error persists.
Regarding your suggestion:
I removed the step where powerbi suggests a data type and directly put the type I assume to be correct.
Three follow-up questions on my end here:
1) In case it is a data type issue, why isn't PowerBi stating the corresponding error (instead of unspecified error)?
2) Sometimes (1/10 chance) my query finishes without error. Is it sometimes by accident skipping the error lines?
3) I have applied "remove error" steps on all files, shouldn't those catch the error?
Best regards & thanks in advance!
Using the method i described above - I appended two tables (one that contained an error) - and this is what i learned:
1. With an error in the column - Power BI still imported the query to the model - (it just removed the error values - and left the cells blank). I didn't get any alerts...
2. However, if I sorted the column with an error in it I get this
Notice the text is similar - but a little different from yours.
You may have to keep working with the source data to try and isolate the table that is causing the problem. Since your alert says "unspecified" it's not clear what part of it is causing the issue.