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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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