Forum Discussion

msabrooks's avatar
msabrooks
Copper Contributor
Mar 08, 2019
Solved

Power Query and dynamic URL

Hi,   I have been beating my head against the wall for 2 weeks trying to figure out how to get the power query from web to work by updating a dynamic URL by data input from a cell.   Below is the...
BI & Data Analytics
Need Help - Dynamic URL from cell for Power Query from Web
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 08, 2019

    Hi Mike,

     

    Sorry, but I didn't catch what exactly doesn't work. Based on your code you have in your sheet table URL with the column named Value from first row of which you take your url as parameter.

     

    For only one cell which you use as parameter I'd not use table, just name that cell (let say as URL) and get parameter as

    ...    
    GetParameter = Excel.CurrentWorkbook(){[Name="URL"]}[Content],
    URL = GetParameter[Column1]{0},
...

    but in general that's only cosmetic

Resources