Update data via merge/adding excel tables

[StasM]

Hi guys,

Could you please clarify, how to combine/add/merge amount of data tables with same columns.

Example: I have weekly results of sales. Let's suppose with 3 columns: data, salesman, revenue. Every week I get new data, transform in the same 3 columns tables (but cannot combine it into 1 excel table due to amount of data). At the end I have weekly files with same 3 columns.

Can I somehow add it in the modelling or other parts and update all figures in dashboard?

[GilbertQ]

Hi there

Another option could be, if you are getting the files supplied each week you could put them into the same folder.

Then when you select get data, you select the Folder Option as shown below?

The advantage of this is that you would not have to Append or combine any Excel tables. 

As well as each week when you get a new file, you just save it to the same location, and then simply click Refresh in Power BI Desktop.

[starmoonknight]

Hi @StasM

As long as you've got the same number of columns, consistent data types and columns are in the same order, simply append new tables to the one in your data model using Query Editor. Either click Append Queries in Home Tab or use Advanced Editor in View Tab

FYI, Merge is join while Append is union.

Cheers

[v-haibl-msft]

@StasM

You can also input the table names in Advanced Editor with power query to get the appended table.

Best Regards,

Herbert

[BhaveshPatel · Accepted solution]

Yes, You can add it into your table using append table operation in the Query Editor.

You can watch this VIDEO to understand how it works.