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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
AKF75
Regular Visitor

Adding in new data to existing data

I have an existing data set that is working fine.  When I try to add the new months data I cannot figure out how other than re-doing the entire thing.  I tried to copy the new table and past it in the editor, however it was too large.  Any thoughts?  I am sure there is an easy way.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Assuming the structure of the table didn't change you can append the table with data for new months to the existing table wih data for previous months. Read more about how to append a table to another one here: http://radacad.com/append-vs-merge-in-power-bi-and-power-query.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Assuming the structure of the table didn't change you can append the table with data for new months to the existing table wih data for previous months. Read more about how to append a table to another one here: http://radacad.com/append-vs-merge-in-power-bi-and-power-query.

I thought I could append it.  Just need more practice with that function.  Now at least I know it can be done.  Appreciate the help!

Hi @AKF75,

For example, your resouce table including Jan to Mar month values. You unload it to Power Bi desktop by "Get Data" from fileA. Now you have the new only Apri value in another fileB, you want to add it to Power BI desktop, you can use the Append function as @Anonymous posted. Append fileA and fileB to one table.


For now, if the fileA including new values from Jan to Apri, you just click "Refresh" in Power BI Home page. You will update your table.

Best Regards,
Angelia

Thank you.  I am trying to work with the one drive to refresh data moving forward.  Appreciate all the help.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors