cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
arjun2506 Frequent Visitor
Frequent Visitor

Adding New Rows to table every month

Hello

here is what I am trying to do: 

I have a table, say, "ExistingData" that has data from January till May (pulled in from an excel workbook). Now, I have data for the month of June in an Excel workbook (say "NewData.xls"), which I want to append to the ExistingData. Using the Append query function helps me do this, but only once. 

I need to be able to do this every month, by hitting refresh. (The new data will be saved in the same path).

 

Is there a way to do this?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User IV
Super User IV

Re: Adding New Rows to table every month

@arjun2506 did you looke at the video provided in that post, combining in that is appending excel files.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Super User IV
Super User IV

Re: Adding New Rows to table every month

Hi,

See the video at this link - https://www.youtube.com/watch?v=yL11ugShdrk.


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

View solution in original post

4 REPLIES 4
Super User IV
Super User IV

Re: Adding New Rows to table every month

@arjun2506there are many blogs/posts on combining excel files, here is similar post which can help.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





arjun2506 Frequent Visitor
Frequent Visitor

Re: Adding New Rows to table every month

Hello @parry2k , thanks for the reply.

Combining 2 excel files is not exactly what I am looking for. I need a way to add new rows to my ExistingData every month, when I hit refresh in PowerBI Desktop. The source excel workbook "NewData" would only include rows for the current month, while the collection/accumulation of all data for previous months would be in the "ExistingData" table in powerBI. 

So, essentially I need a method to append data to the master table, while retaining existing data in there. All this without having to go in to query editor everytime and append it.

Is there a way to do this?

Super User IV
Super User IV

Re: Adding New Rows to table every month

@arjun2506 did you looke at the video provided in that post, combining in that is appending excel files.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Super User IV
Super User IV

Re: Adding New Rows to table every month

Hi,

See the video at this link - https://www.youtube.com/watch?v=yL11ugShdrk.


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

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors