Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Append Daily from one csv file to master table - Need Power Query

HI Members, I have one excel file in a folder which gets replaced everyday with that's day data . I need to append everyday to the master table i built in power bi. I used code like: =table.combi...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

So, How do I achieve using incremental refresh? I know the basic steps but not able to relate it with my issue.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    My question remains the same .  How do i append data  to master table from a daily report which keeps replacing its entire data set daily. Everyday it replaces previous day data and paste current day data. I need to add everyday data to master table

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      6 years ago

      Hi Anonymous 

      If the "daily data" from your source file changes every day, then it would update to newest data in power bi and remove the yesterday's data.

      You can create a folder which you add everyday data into, then import the folder into power bi.

      https://insightsoftware.com/blog/power-bi-load-data-from-folder/

      After some transformation, you can append the daily data table with the master data table.

       

      Best Regards

      Maggie

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Did you try using the Append Query in the power query editor?