Hi,
I have 12 power querys for monthly data, sourced from an access query in a local database. This Access source query (qryExpenseByYear) selects data for a full year.
I assume for each month's power query...it is rerunning the full year's access query, which seems inefficieent with network etc.
IF so...should i just bring in the full years data once into a sheet, then have each of the monthly Power queries go against that sheet?
(Here's sample of monthly for January query, with each subsequent month's query just changing the [monthnbr]
Bookmarks