Solved: Parameterizing URL query string for data lookup

espo4life · ‎04-28-2020

I have a datasource from the web

= Json.Document(Web.Contents("http://api.weatherstack.com/current?access_key=4d874fb78b08839d1deb2ffc3e6168d2&query=39.6177,-86.15..."))

I want the query values (long, lat), to be populated from the values in another table.

I have a parameter named Location, which will be used to look up the long/lat for that location. I want to plug those values into the query string above.

I am not savey enough to figure it out or know exactly what to search for. Any help would be gratley apreciated!

mwegener · ‎04-28-2020

Hi @espo4life ,

check this out.

https://community.powerbi.com/t5/Desktop/API-Calls-from-column/td-p/568646

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials

View solution in original post

mwegener · ‎04-28-2020

Hi @espo4life ,

check this out.

https://community.powerbi.com/t5/Desktop/API-Calls-from-column/td-p/568646

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials