Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
arjun2506
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

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

Ashish_Mathur
Super User
Super User

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

5 REPLIES 5
Ashish_Mathur
Super User
Super User

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/
parry2k
Super User
Super User

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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?

Hi @arjun2506 did you find a way to do this?

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.