Forum Discussion
[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ł
- Anonymous9 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
- tjdImpactful 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.
- AnonymousNot applicable
So how do I solve this?
- AnonymousNot 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
- paweldmHelper 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
- MarcelBeugCommunity 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.