Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Expression.Error: We cannot convert the value null to type Number. mysteriously appeared

I'm working in an ERP reporting project and I have relatively complex PBI and PQ set with dozens of tables and processing steps.   Everything were fine until yesterday when I started to get error E...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    OK, I finally managed to solve this issue. Error message was in the end misleading.

     

    The error "Expression.Error: We cannot convert the value null to type Number" happened already in earlier steps. For some reason it got expanded to all the columns at the later steps.

     

    The root cause was unexpected values in the code list merged in earlier steps.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

 

It might be UI did not load the error (limited rows), you can enable Column quality to see if any error and try to do some error handling?

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Vera,

     

    Thanks for the comment.

     

    Unfortunately column quality indicator displays no error as seen from the below:

    I have also tried to Remove Error, Remove Blank Rows, Keep Errors etc,

     

    All I get is

     

    Normally you would get the errorneous rows visible and get more information what's going on but not in this case.

     

    Jani

    • SuryaP's avatar
      SuryaP
      New Member
      3 years ago

      Right Click on the Column which has errors and Click on "Drill Down" which removes Error.

      • allenabraham's avatar
        allenabraham
        Frequent Visitor
        2 years ago
        This weird step in fact helped me!