DataFormat.Error while data should be fine

[Aavikkosoturi]

Hey, I am getting this error while trying to do basic API coordinates pull from Bing following This youtube video. 

"An error occurred in the ‘Query1 (2)’ query. DataFormat.Error: Xml processing failed. Either the input is invalid or it isn't supported. (Internal error: Data at the root level is invalid. Line 1, position 1.)
Details:
[Binary]"

Steps I've tried to fix this:

I've created a new basic excel file as .xlsx where I wrote couple addresses to make sure that the data itself isn't corrupted anyway. I've saved this new file to dekstop to make sure it's not problem with the cloud I'm using.

I know that my key itself isnt the problem as I can manually pull test samples and it works correctly.

The relevant part of the code is here (the parts I've modified). 

let
Location = (Address as text) =>
let
    Source = Xml.Tables(Web.Contents("http://dev.virtualearth.net/REST/v1/Locations?countryRegion=""FI""&addressLine="&Address&"o=xml&key=MyKeyHere")),

Any ideas where to start from?

[Anonymous]

Hi  @Aavikkosoturi  ,

This is a link to related content, hope it will help you:

https://forums.asp.net/t/1316862.aspx?Data+at+the+root+level+is+invalid+Line+1+position+1+

https://powerusers.microsoft.com/t5/Building-Flows/Troubles-parsing-XML/td-p/551062

https://stackoverflow.com/questions/17795167/xml-loaddata-data-at-the-root-level-is-invalid-line-1-p...

https://forums.asp.net/t/985790.aspx?Data+at+the+root+level+is+invalid+Line+1+position+1

https://www.codeproject.com/Questions/668540/data-at-the-root-level-is-invalid-line-1-position

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Aavikkosoturi]

I should add that I have version 2008 (Build 13127.21624)