Hello guys! I am currently querying from a web that just allow maximum 60 calls per hour. I currently query 18 tables (and just keep them as a connection) and then i merge all of them, one by one, and have I have 17 merges, then i load the result to a table. I hit the maximum hourly calls every hour, so I am wondering if power query queries once every single table + then queries it again every time i merge one extra table. Is that correct? Is there a way to prevent this?
Thank you in advance!
Laura.
Hi Laura,
Welcome to our forum! Your merge query will be triggering all the individual queries to make another call to the website, as explained here. This article is referring to Power BI, but the same Power Query tool is in Excel so the points are still relevant. However, the solution is to create a data flow, which we don't have in Excel.
Please also see this post for insights into how Power Query is refreshing. Be sure to read the Q&A at the bottom. That said, I'm not sure there's a solution.
Mynda
Hi Laura,
An alternative approach would be to create your query(ies) to the web source and load those results into a table(s) in Excel.
Then the other queries that do your merges etc can load the data from the table(s).
Regards
Phil
