Forum Discussion
Solved
Run multiple queries at once
Hi, I am working on a report that requires 3 queries to run for the complete report. Each query has different source files and steps to execute. I would like to know if it is possible to create ...
Oh, well Power BI does all of that automatically when you schedule a refresh.
Also, in Desktop, if you hit the Refresh button on the home tab, all queries refresh.
Yeah, the issue is that one table is created per query. So, even with references and things like that, I'm not sure how you would get them to run sequentially. Is there a reason they need to run sequentially?
Hi,
The sequence in which they run is not important, it is just that I want to update all pivot reports in one click. I know my Pappenheimers and as said it can be easily done with some VBA code.
Oh, well Power BI does all of that automatically when you schedule a refresh.
Also, in Desktop, if you hit the Refresh button on the home tab, all queries refresh.