Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper II
Helper II

Incremental Load



I am wanting to create a record of the daily prices off a website. 

I have had a go at creating an incremental load, but no data shows up in my table, can anyone point me as to what I am doing wrong? Ideally I would see each day's data with a new refresh. 



This is the blog I was looking at 


Link to PBIX file Ink Prices.pbix

Helper II
Helper II

Thank you for your reply! I can see data coming in, but the data keeps over writing when I refresh, rather than bringing in the new day's data. I am refreshing and republishing from the desktop app to the workspace, do I have to set up an automatic refresh? Thank you for your help

Did you ever find a way to accomplish this?  I have a similar use-case where I'm querying a source which doesn't store historical data.  I want to query the source each day and get the currently values and store that information historically in a PowerBi dataflow.  This sounds similar to what you're trying to accomplish here.

Hi @MattBossert , no I couldnt figure out how to stop the historical data from being overridden, @Jihwan_Kim is this because I was pushing through a manual refresh from Desktop app? Thanks again for your time

Helper II
Helper II

Ok great thank you so much, I've made that wee change and will check tomorrow if its working! 

Hi @watje255_ju ,


Could you tell me if your issue has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your issue .

Best Regards,

Rico Zhou

Super User
Super User


In the Power Query Editor, the below might be one of reasons.

And please be noted that incremental refresh is shown in the Workspace in Power BI Service after the dataset is refreshed from the second time (not from the first time refresh), not on the Power BI Desktop.


Try to change >RangeStart and <=RangeEnd




If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

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

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors