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.
When replacing #N/A use the replace errors option and replace with the word null. It doesn't do anything if you leave the replacement blank like it normally would in Excel or other programs but it doesn't really give you any indication that blank isn't doing anything.