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.

gvg's avatar
gvg
Post Prodigy
4 years ago

mussaenda ,

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.

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.