Forum Discussion

gvg's avatar
gvg
Post Prodigy
4 years ago
Solved

We cannot convert the value null to type Number

Hi, I know there is a number of threads with this title, however none of them provide clear answer. At least for my case. I am getting this message when trying to sort a column with integer values....
Need Help
  • mussaenda's avatar
    mussaenda
    4 years ago

    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.

mussaenda's avatar
mussaenda
Community Champion
4 years ago

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.

gvg's avatar
gvg
Post Prodigy
4 years ago

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.