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
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 @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 .
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.