Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

Reply
Anonymous
Not applicable

Append new data only

Hi all,

 

I'm connectint to a web page and importing xml.

 

I want to be able to download the data for yesterday and append to a historical table, rather than refreshing all the data each day.

 

I've tried to append to a new query but it seems that this historical query would need to be refreshed which defeats the object.

 

The dataset is too large to refresh in total on a daily basis.

 

Does anyone have any ideas?

 

Thanks

 

Mike

2 REPLIES 2
v-caliao-msft
Microsoft Employee
Microsoft Employee

@Anonymous,

 

This feature not yet implemented in Power BI. Please vote for this feature here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7288623-incremental-data-loads

 

Besides, here is a similar issue for you refreence.

https://community.powerbi.com/t5/Desktop/Refresh-Data-Append-New-Data-Only/m-p/106168

 

Regards,

Charlie Liao

Anonymous
Not applicable

Hi

 

Thanks Charlie but that solution doesn't work for large datasets.

 

I've voted for the feature but does anyone else have a work around for large datasets?

 

Thanks

 

Mike

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors