I have created this report that uses Pivot tables and Microsoft Query
to populate the Excel file and extract data from a Oracle database. To
increase the security in these reports, I have created a stored
procedure which when run populates a temp table. on which I run the
select statement.

I have been able to run both the commands individually but not one
after the other in Microsoft Query. Can someone please advise me on how
I might be able to run these one after the other. Thank you.

A