Forum Discussion

paweldm's avatar
paweldm
Helper II
9 years ago
Solved

[Expression.Error] We cannot convert the value "" to type List

I cannot find out what the error means. 

 

 

I am following step by step manual from the link:

https://sqldusty.com/2016/04/26/power-bi-and-the-bing-maps-api/

 

First I found latitude and longitude for provinces. The query worked fine.

However in the second step, when I try to add latitude and longitude to county I got the error. 

 

Can anyone help me?

 

Paweł

 

  • Anonymous's avatar
    Anonymous
    9 years ago

    HI paweldm,

     

    As tjd said, the error message show that it can't convert null value, perhaps you can try to replace these null value to a default value before your operation.

     

    Regards,

    Xiaoxin Sheng

7 Replies

  • tjd's avatar
    tjd
    Impactful Individual

    I believe that it's telling you that you have a null value in one of your lat/long fields and it can't convert that to a decimal number.

    • Anonymous's avatar
      Anonymous
      Not applicable

      So how do I solve this?

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI paweldm,

     

    As tjd said, the error message show that it can't convert null value, perhaps you can try to replace these null value to a default value before your operation.

     

    Regards,

    Xiaoxin Sheng

    • paweldm's avatar
      paweldm
      Helper II

      Hi,

       

      I checked my pna table and there are no empty cells. 

      I have found however some errors in new calculated columns with location parameters.

       

       

       Pawel

      • MarcelBeug's avatar
        MarcelBeug
        Community Champion

        It's not a good habit to cross post questions on another forum if the topic is still active here

         

        At least you should mention the cross post.