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

[paweldm]

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ł

[v-shex-msft · Accepted solution]

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]

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]

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.

[paweldm]

Thx for the comment. I will follow your suggestion next time.

Now it has been crossed by you 🙂 

[MarcelBeug]

@paweldm don't forget to update the cross post that a solution was found.

[tjd]

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.

[michelevardaro]

So how do I solve this?