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
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

SergeiBaklan

Diamond Contributor

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

msabrooks

Copper Contributor

Mar 09, 2019

Hi Sergei,

Thanks for the help. That did it.

Thanks again.

Mike.

Forum Discussion

Power Query and dynamic URL

Resources