cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Append excel sheets

Hi,

 

Need your help please. 

 

I have an excel report that comes on a monthly basis. So it is the same report, but different data. the header row is the same always.

Currently what I do is I copy the new data and put them in one single excel sheet month over month.

 

Is there a way, I can combine those report in powerbi without having the need to combine the data in one excel sheet? 

 

 

Thanks,

Mohamed

 

4 REPLIES 4
Highlighted

Re: Append excel sheets

I wrote an article last year about this https://exceleratorbi.com.au/combine-all-sheets-in-a-workbook-with-power-query/



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Highlighted
Super User IX
Super User IX

Re: Append excel sheets

Highlighted
Community Support
Community Support

Re: Append excel sheets

Hi, @abukapsoun 

 

When the number of columns and column names are the same, you can connect to your new excel sheet, load it in. Then in the query editor, go to your existing table and find Append Queries in Home tab. Finally, you should unclick "Enable Load" by right clicking on the new table in Queries pane.

 

If you will have more files in the future like September, October, etc.. data; the better solution is to source data from Folder (by choosing “New Source” >>> “Folder” ). Make sure that both excel sheets are in the same folder and sheet names are the same. Then you can "Combine and Load".

 

When you connect data this way, every new month, you can copy the new month's excel sheet into the same folder and then "refresh" from Power BI Desktop. All files in the folder (including the new one) will be loaded in and combined.

 

For further information, I'd like to suggest you  refer Loading Data From Folder .

 

Best Regards

Allan

 

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

 

 

Highlighted
Super User V
Super User V

Re: Append excel sheets

Hi,

Watch this video - https://www.youtube.com/watch?v=yL11ugShdrk.

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors