When you make duplicates or references to your original query in your report/excel sheet do the duplicate/reference queries also make a rest call to get the data? Or do they work off the data returned from the source query?
Here’s the architecture.
Make the epicor BAQ.
Pull it into EXCEL using power query.
Duplicate the query for a summary table or whatever.
Now you have two queries in the excel sheet…
Do each of them make a REST call when you click refresh all?
I would assume it would.
I’ll look at my app server log in a second and confirm my friend.
I saw one call made even when I duplicated the query, but that was a quick glance.
So I made a query connection and then duplicated it and clicked refresh all in excel and both loaded, but in the server log I only saw one trace of the BAQ ran.
I need to do a “reference” action in excel as well.
My hope was that Excel only calls the source query once and anything that was built off the query is executed/performed after the source query is done running… I would think that HAS to be the way it would work otherwise you’d run the risk of data conflicts in resutling query sets… I.e. the source baq ran and then inbetween the next, duplicated, query running and that one an order was entered so the second query has that order and the first one doesn’t.
In short, pretty sure it calls the BAQ one time in excel and if you duplicate that query or reference it in another query connection it doesn’t call the BAQ again.
Just depends on how smart they made it, I’m hoping you’re right.