Get power query content from a cell

[vivis93]

Hi it is possible to replace a text in the source of power query from a cell in sheed eg.

let
    Source = Xml.Tables(Web.Contents("http://api.openweathermap.org/data/2.5/forecast/daily?q=[B]Old%20Trafford,%20Sir%20Matt%20Busby%20Way,%20Stretford,%20Manchester%20M16%200RA,%20UK[/B]&mode=xml&units=metric&cnt=15"))
in
    Source

i want the text Old%20Trafford,%20Sir%20Matt%20Busby%20Way,%20Stretford,%20Manchester%20M16%200RA,%20UK
to be replaced automatically with the cell A1 from the sheed2

 

[ImkeF]

You need to give your cell the name: "Substring". Then the following code should work, provided that you switch to Fast Combine in your Privacy Setting:

let
    Source = Xml.Tables(Web.Contents("http://api.openweathermap.org/data/2.5/forecast/daily?q="&Excel.CurrentWorkbook(){[Name="Substring"]}[Content]{0}[Column1]&"&mode=xml&units=metric&cnt=15"))
in
    Source

see also: Iterating over multiple pages of web data using Power Query | Matt Masson