Forum Discussion
Cache consult
Resident Rockstarhey,
here its how you could clean manually the cache on the power bi desktop:
on the options and settings panel,
but I will recommend trying to separate the source API reading if its 10 times 10 files open 10 queries get the data and make a function to tranform them and them append them (if they all have the same headers). instead of reading all 10 items at once in the same run of the source. them disable the 10 queries from data load and left only the new appended query.
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
- StefanoGrimaldi
as 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