November 27, 2020
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!
July 16, 2010
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.
October 5, 2010