Forum Discussion
Solved
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, rev...
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.
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.