Forum Discussion
PowerQuery URL's are suddenly dependent
Hey all,
Working with a web API that has a page limit that I've worked around by using multiple queries and merging them, editing the URL's with page_number=0 / 1 / 2 to access the pages of data I need.
I'm not quite sure where or how, but at some point while I was working in the sheet (not editing anything to do with the queries) Query 2 and 3 became dependent upon the Query 1 URL: they all now display the data of page 0 (what only Query 1 should see).
Whenever I attempt to change the URL's of Query 2 or 3, the two Queries that I did not edit receive the same URL change - no matter if it's changed from advanced editor or data source settings.
Any ideas on how I can correct this without having to redo my queries from scratch? Also worried that this issue may arise again even if I do redo them...
Thanks for reading!
Owen
If in browser you access the same URL and change pages, do you see what desired?
- Yes - both URL's display the desired/correct data
Thus pages are changed by URL address, not by JavaSript. If so afraid I can't help without the sample, if someone else has another guess.
