Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi,
I would to append two tables for every refresh,
for exmple
1st refresh - history_data=history data + 1st_new_data becomes history_data
2nd refresh - history_data(includes 1st_new_data) = history_data + 2nd_new_data
how to achive this concept using power query or some other else
thanks in advance
hi, @saranrajk
It sounds like Incremental refresh in power bi.
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
The filter on the date column is used to dynamically partition the data into ranges in the Power BI service. Incremental refresh isn't designed to support cases where the filtered date column is updated in the source system. An update is interpreted as an insertion and a deletion, not an actual update. If the deletion occurs in the historical range and not the incremental range, it won’t get picked up. This can cause data refresh failures due to partition-key conflicts.
By the way, Incremental refresh is only for Power BI Premium for now.
Best Regards,
Lin
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 51 | |
| 24 | |
| 13 | |
| 12 | |
| 11 |