Forum Discussion

rdoggart's avatar
rdoggart
Regular Visitor
9 years ago
Solved

Using web services from Power BI

  I would like to know is it possible in Power BI to add a new column to a table that would be populated via a call to a web service. I have a table with easting and northing map data that I need t...
Need Help
  • TomMartens's avatar
    TomMartens
    9 years ago

    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