Forum Discussion
Append Daily from one csv file to master table - Need Power Query
Community ChampionRight, so without incremental refresh, Power BI replaces all of the data in a table with the refreshed data. There are laborious work-a-rounds for this where you create a new query every day and add it to your table.combine and such, turning off data load for the last query. Another (better) work-a-round is to simply rename the file every day so that they build up in the folder and use a Folder query.
So, How do I achieve using incremental refresh? I know the basic steps but not able to relate it with my issue.
v-juanli-msftCommunity Support
Hi Anonymous
If you have problem, share with us.
https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh
https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-incremental-refresh
Best Regards
Maggie
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
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