Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Credentials not working for Bing Maps Geocoding API

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!

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      I tried this and the issue still presitsts after I remove the index colomn step and the filtered rows step.