Append 12 data sources into one table without creating 13 tables

[rmsl]

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

[amitchandak · Accepted solution]

@rmsl , refer to the way in this video

Merge Queries, Why not Merge the code: https://youtu.be/YOFs39RCPfQ

[rmsl]

That's exactly what I was looking for !

I will apply same logic to append it - that will reduce my number of tables which is what I was after!

Any tips on best practices here?

Thanks

Remi