Forum Discussion
MikeO
Helper I
Helper I"OLE DB or ODBC error: [dataformat.error] invalid cell value '#NAME?'
I have connected to a single table in excel and whenever I try to close and save the query editor, I get the above message. In reviewing the table in query editor I see the bottom row is all errors;...
My suggestion would be to correct the error where it originates: in Excel.
dkay84_PowerBI
Microsoft Employee
Microsoft EmployeeIn addition to Marcel's comment, have you tried removing errors as a step in your query editor flow? If that doesn't work, you can try filtering, and lastly add a new column that checks if the value is error return null otherwise return the original value. Then use that column (and remove/filter the blank row if needed).