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.
Ill share my issue that lead me to this error and my solution:
I did a power query from a spreadsheet. I filtered everything down to what I wanted but was left with "error" cells and nothing loading into the new spreadsheet. I tried to remove and replace the "error" cells to no avail. Eventually I figured out that my filtering was what was giving me grief. I went back and removed the "error" cells before I did the filtering and got the results I was looking for.
Hope this helps!