Forum Discussion
Query erroring out when loading the lat and long from Bing API
I have fixed some of my problems using "try" and "otherwise" as explained in this post:
https://community.powerbi.com/t5/Desktop/Get-Address-from-Lat-Long-in-Bing-maps/m-p/1245768
However, some completely legitimate addresses still throw errors.
jimgores
Regarding to the datasource error you could refer the following methods, this error can be caused by many reasons, there is no specific fix to this issue, you have to troubleshoot step by step.
"Web.contents failed to get content from site URL" displayed after trying to establish a connection in Power BI to Assemble | Assemble Products | Autodesk Knowledge Network
Solved: DataSource.Error Web.Contents failed to get data f... - Microsoft Power BI Community
For the address error, this is most likely because you had multiple data types in one column, for example the " " blank is record as text but other value(lat/long) could be integer. You can try replace " " to null or replace error to null.
Solved: Cannot convert value null to type List - Microsoft Power BI Community
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.