Adding in new data to existing data

[AKF75]

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.

[Anonymous · Accepted solution]

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.

[AKF75]

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!

[v-huizhn-msft]

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

[AKF75]

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