Forum Discussion
I'm having problems with power query trying to pull a table from a website. The table changes daily.
I have a website I'm trying to pull a table from daily and import this table into excel. I'm using Power Query. I'm able to get the table to pull in but can not figure out how to get it to change daily with the new days data. Here is the web address.
As you notice at the end of the address there is a date I would like to be able to pick a new date from a calender from a designated cell in my spread sheet. I have tested changing the date manually works inside the data source. I would like to be able to pick the new date before it runs its query.
Any help would be appreciated.
Ken Puls describes a way to link queries to cells here: https://www.excelguru.ca/blog/2014/11/26/building-a-parameter-table-for-power-query/
I think that is what you need.
