Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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ł
Solved! Go to 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
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
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.
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.
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?
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |