cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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

I cannot find out what the error means. 

 

Error.png

 

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ł

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

6 REPLIES 6
Highlighted
Impactful Individual
Impactful Individual

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

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.

Highlighted
Community Support
Community Support

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

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Highlighted
Helper II
Helper II

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

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

Highlighted
Community Champion
Community Champion

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

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.

Specializing in Power Query Formula Language (M)
Highlighted
Helper II
Helper II

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

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

 

Now it has been crossed by you 🙂 

Highlighted
Community Champion
Community Champion

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

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

Specializing in Power Query Formula Language (M)

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors