none
Power Query web address based on Excel cell RRS feed

  • Question

  • We have a named Range that consists of one cell. In there is a string for a web address. This is then used as the source. However when the query is refreshed it always brings back the same data. The data should change when it goes to a different page. Its like the query is not updating. Its just executing a stored query. How do I refresh that query?

    Thnaks

    E

    
    

    let

    name = Excel.CurrentWorkbook(){[Name="Parameter"]}[Content],
    var= name{0}[Column1],

    Source = Web.Page(Web.Contents(var)),

        Data0 = Source{0}[Data]
    in
        Data0

       
    Friday, July 31, 2015 1:47 PM

Answers