Forum Discussion
Solved
Dynamically Change date range of web source (api link)
Im new to powerquery and have made a connection to a site using APi key. im trying to avoid going into the source every day to look at yesterdays data or any previous day. how can i do this dynamic...
AI14You need to include to and from in double quotes .... & "from=" & DateParameter & "to=" & DateParameter & ....
AI14 Are you using Excel for this? Then you can create a new query from a particular cell and then reference that query in the above code.
would the code stay the same or do i need to reference the sheet, cell number?