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...
TylerVono , the data type of a column is the number type where this value is coming. So in the first change type, change the data type to text or replace the value before that