Forum Discussion
DataFormat.Error: Invalid cell value '#N/A'.
I'm trying to pull in a value from another table using merge. I'm getting the following error: DataFormat.Error: Invalid cell value '#N/A'. I've looked at other forums to determine what is causin...
Are you using excel as datasource? Sometime in excel in formulas you have value "#N/A" and that could be the root cause for this. You need to replace that value using query editor with "null" or space and I guess that will do it.
Can you replace the #N/A in power bi / query editor? I have tried with replace values and replace errors and it didn't worked. thanks.
I agree, fixing the data doesn't seem to be the right answer. We should be able to resolve the bad data within the query.