Forum Discussion

AKF75's avatar
AKF75
Regular Visitor
9 years ago
Solved

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 th...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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.

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

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's avatar
AKF75
Regular Visitor
9 years ago

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