Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am using the geocodeing api to get Lat and Lon data showen below:
let
Location = (State as text, Suburb as text, Pcode as text, Address as text)=>
let
Source = Xml.Tables(Web.Contents("http://dev.virtualearth.net/REST/v1/Locations?countryRegion=""US"""
&"&adminDistrict=" & State
&"&locality=" & Suburb
&"&postalCode=" & Pcode
&"&addressLine=" & Address
&"&o=xml&key=Ak1LEVAlLWaUn....................................")),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Copyright", type text}, {"BrandLogoUri", type text}, {"StatusCode", Int64.Type}, {"StatusDescription", type text}, {"AuthenticationResultCode", type text}, {"TraceId", type text}}),
#"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"ResourceSets"}),
#"Expanded ResourceSets" = Table.ExpandTableColumn(#"Removed Other Columns", "ResourceSets", {"ResourceSet"}, {"ResourceSet"}),
#"Expanded ResourceSet" = Table.ExpandTableColumn(#"Expanded ResourceSets", "ResourceSet", {"Resources"}, {"Resources"}),
#"Expanded Resources" = Table.ExpandTableColumn(#"Expanded ResourceSet", "Resources", {"Location"}, {"Location"}),
#"Expanded Location" = Table.ExpandTableColumn(#"Expanded Resources", "Location", {"Address", "Confidence", "GeocodePoint"}, {"Address", "Confidence", "GeocodePoint"}),
#"Expanded Address" = Table.ExpandTableColumn(#"Expanded Location", "Address", {"FormattedAddress"}, {"FormattedAddress"}),
#"Expanded GeocodePoint" = Table.ExpandTableColumn(#"Expanded Address", "GeocodePoint", {"Latitude", "Longitude", "UsageType"}, {"Latitude", "Longitude", "UsageType"}),
#"Filtered Rows" = Table.SelectRows(#"Expanded GeocodePoint", each ([UsageType] = "Display"))
in
#"Filtered Rows"
in
Location
I then used this code to invoke a custom function that pulls in the info for state, suburb, Pcode and address. This works when I limit the data to around 10 rows as showen below:
However when I remove the index filter to include more than ~ 10 rows I start to get a credential error message that I am not able to resolve (showen below):
None of the credential options are working and am stuck on how to fix this.
Thanks!
Hi @mhgottsc ,
If you revert to the original steps, are the errors still there?
Try removing the step to delete the index columns and the step to filter the rows to see if the error exists.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I tried this and the issue still presitsts after I remove the index colomn step and the filtered rows step.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.