Append 12 data sources into one table without creating 13 tables

Hi All,

Not sure if that is possible at all but basically, I have a set of data each month with the exact same format. Each month, it's a lot of data and the data source doesn't allow me to extract it as a YTD. Therefore after one year, I end up with the following;

12 tables that are connected to those sources

1 append table which is a combined of those 12 tables which is used in the data model.

My question; is there a way to avoid having 13 tables in my model and to connect and append to those sources directly via one single query?

I could of course copy/paste the data of each data source into one single master file and then connect to pbi but I was wondering if there was another way in pbi before I start this exercise?

Many Thanks,

Remi