How to combine data from different files

[Migscruz]

Hi,

How can i combine the data of different files of excel? I have 3 tables:

1. Table number 1 has the sales by day, product id and store in december.

2. Table number 2 has the sales by day,product id and store in november.

3. Table number 3 has the sales by day, product id and store in october.

Having this 3 tables combined in PBI should let me have one single table with all the sales of each day of every month.

P.D: I cant put this 3 tables in one excel because each table has one 1million rows. 

Thanks 🙂 

[v-deddai1-msft · Accepted solution]

Hi @Migscruz ,

You can use combine file in query editor. Put these three files in one folder and connect to the folder via Power BI. 

For detailed steps , you can follow :https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-combine-binaries

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Ashish_Mathur]

Hi,

Wath this video - Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks - YouTube.

Hope this helps.

[Anonymous]

Hi @Migscruz,

You can append the three tables into one table in the power query editor.

On the home ribbon go to Transform Data -> Append Queries (or Append Queries as New if you want to create a new table, leaving the three others unchanged). Then select three or more tables and add all the tables to the "Tables to Append" box.

I hope this helps!