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]

Please Login or Register  to view this content.