Jun 07 2017 10:01 PM
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.
Jun 08 2017 01:36 AM
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.