Forum Discussion
Update data via merge/adding excel tables
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?
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.
4 Replies
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.
You can also input the table names in Advanced Editor with power query to get the appended table.
Best Regards,
Herbert
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
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.
