Forum Discussion
Cache consult
Hi
He queries 10 times to give 10 different results and to add these results in a single spreadsheet, the question that when he does the 10 times he only saves the first query Only the act of clearing the cache does not solve it because the query is all at once, I needed something in Power Query that would eliminate caches or that would have 10 different queries Actually there are not 10 consultations, but 70 to 100 consultations, this is just a test
Thanks
Resident Rockstaras far as I know you cant actually loop in a same source multiple queries in it for a unique queri as the source search for 1 record 1 query to input for source you could try another approach as creating a sharepoint repository that get this 100 consultations files from a push flow from a update request of power bi (but I think you need premiun caps for this) and them connecto to that sharepoint folder and combine all the files in it.
- StefanoGrimaldi
https://community.powerbi.com/t5/Desktop/Looping-through-Parameters-for-API-calling/td-p/574796 also here I found something that could be a solution for what you asking for or point you in a better direction them my answer.
I tried to add the following code in the Header, but still keeps saving only the first query and the rest being all the same
#"Cache-Control"="no-cache, no-store, must-revalidate"
The other time I had this problem, this code solved it, but this time it's not working