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.

Techzill's avatar
Techzill
New Member
2 years ago
I am working on a powerBi report and I pulled data from Azure cost management. I tried loading the usage details data into powerquery and I got this.

Expression.Error: We cannot convert the value null to type Record.

Details:

Value= Type=[Type

I have tried modifying the M query from the advanced editor but I am not getting it right.

This is the  M query code

 

let
    source = AzureCostManagement.Tables("Enrollment Number", "10xxxxx", 12, [startDate=null, endDate=null]),
    usagedetails = Source{[Key="usagedetails"]}[Data]
in
    usagedetails