Make time series of daily data

[Anonymous]

Hi,

I have access to a web page with daily fund data. This page is updated each day, but has no price history, ony current days value.

I have imported the information from the web page in Power BI and can see todays price. 

My question: Is there a smooth way to "save" the daily updates from the web page consecutively in Power BI so that I can create a historic price chart? 

[v-eqin-msft · Accepted solution]

Hi @Anonymous ,

According to my understanding, you want to save historical data from a web page that is updated daily,right?

Firstly, ideas about automatically exporting data on different time basis has been submitted in these links, please give your votes at power bi site's feedback

Allow to create historical records

auto historical comparison of data

For more information,you can refer to

Storing and using information from a dynamic data source using PBI desktop

How To Keep Historic Data In Power BI - Advanced Query Editor Concepts

Keep The Existing Data In Your Power BI Dataset And Add New Data To It Using Incremental Refresh

Using Powershell-script and use a task-scheduler to run it:  https://github.com/djouallah/PowerBI_Desktop_ETL

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , There is Dax append method, see if that  van help

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/