Forum Discussion
We cannot convert the value null to type Number
Hi gvg,
as per my experience on this error, I am replacing error with text then filter the column with the replaced value.
So I can check why this value is giving error and adjust the applied steps.
Hope this helps.
tried that. I even get error after I try to get all values loaded in the filter box after I replace errors with some text value:
Strangely enough Power Query displays null in the filter box, but still complains that it can not convert null to type Number.
If there is no any confidential data, you can DM me the file to check.
Else,
The is a value that Power query cannot convert to the data type you chose which shows error.
Well, I managed to figure out what was the problem by deleting records until I saw the error. It looks like PQ does not replace all kinds of errors. Errors that were not captured by "Replace Errors" were those that arose as a result of merging tables.
Anyway, thank you for the tip.