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.

Anonymous's avatar
Anonymous
Not applicable
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.

AKF75's avatar
AKF75
Regular Visitor
9 years ago

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'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.