Forum Discussion
OLE DB or ODBC error: (DataFormat.Error) Invalid cell value '#N/A'
Hello, My datasource in its raw form does create fields with #N/A. However, even after using the appropriate: Replaced Value and Replaced Errors at the Power Query "Applied Steps" level across a...
Hi TylerVono Remove the "Removed Blank Rows" step. I have the same issue: if I apply the "Removed Blank Rows" Power Query outputs the error, but if I let the blank rows so Power Query doesn't finds any #N/A it loads all the data without problem.
To remove the blank rows use "Remove Empty" in any column instead.
I don't know what's the issue with the "Removed Blank Rows" feature but it generates that problem.