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 ...
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.
- No problem Sergei!
For anyone viewing this thread at a later date with the same issue: I was able to circumvent this by going to data -> recent sources and loading up the non-applied desired URL, and pasting in the advanced editor script from the query I'd like to use on this second URL. For some reason, excel likes it if it is done this way...
