Duplicate Budget Data

[MikeDBMan]

I have a table of data which I'll call budget. It is for a month and all 12 months are exactly the same. Currently I set up to pull in the data 12 times and change the month number each time and then append all those queries into 1 query that has the data 12 times, one record for each month. I think this may be taking a long time to execute and was wondering if anybody has a suggestion on how to speed up this process as I think it slows down the refresh. I need the data for each month so that the budget data can be compared to the actual data for each month.

 

[johnny51981]

Are you making any updates or calculations after the 12 have been appended into 1? If so, maybe do those changes on the 12 prior to the Append. This includes filtering out rows, any grouping.

Power Query, while a hefty tool, enjoys tasks with as little data to carry. So remove columns and filter out rows as quickly in your steps as you can.

This will help speed up your refresh a great deal.