Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
paweldm
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
v-shex-msft
Community Support
Community Support

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

7 REPLIES 7
v-shex-msft
Community Support
Community Support

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.

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

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)

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

 

Now it has been crossed by you 🙂 

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

Specializing in Power Query Formula Language (M)
tjd
Impactful Individual
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.

So how do I solve this?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.