Using web services from Power BI

Hey,

I would start with this post by Chris Webb

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/

unfortunately I'm currently not able to provide a solution.

Nevertheless, hope this helps

Edited somewhat later ...

I created a little table that consists of two columns (datataype = text)

Then I added a Custom Column using this Formula

Web.Contents(
    "http://beta.ngs.noaa.gov/gtkws/geo", 
    [
        Query=
        [
            northing=[northings],
			easting=[eastings],
			zone="56",
			hemi="S"
        ]
    ]
)

Due to the fact that Web.Contents returns a binary I used Transform -> JSON from the context menu of new column.

Finally I expand the record and select the appropriate columns

The steps

Here you go