topic Re: Incremental Load in Desktop

Incremental Load

watje255_ju — Mon, 24 Apr 2023 01:04:34 GMT

Hello,

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.

Thanks!

This is the blog I was looking at

https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only

Link to PBIX file Ink Prices.pbix

Re: Incremental Load

Jihwan_Kim — Mon, 24 Apr 2023 03:19:33 GMT

Hi,

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

Re: Incremental Load

watje255_ju — Tue, 25 Apr 2023 21:36:26 GMT

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

Re: Incremental Load

Anonymous — Thu, 27 Apr 2023 10:01:38 GMT

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

Re: Incremental Load

watje255_ju — Sun, 30 Apr 2023 21:23:10 GMT

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

Re: Incremental Load

MattBossert — Tue, 16 May 2023 15:55:34 GMT

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.

Re: Incremental Load

watje255_ju — Tue, 16 May 2023 21:36:44 GMT

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