How to download/keep the daily data from a web in power bi?

[jovendeluna21]

Hello,

Anyone who knows how to download/keep the daily data from a web in power bi?

The power bi is connected to a web (https://covid.cdc.gov/covid-data-tracker/#vaccinations) and I need to keep the daily numbers on a table and not just the current data or live data from web since I need to have a trend of any changes. Is there any possibilities? 

Appreciate your help!

[v-shex-msft]

Hi @jovendeluna21,

Unfortunately, current power bi does not support saving daily history records. I think you need to use external tools to do export data operations: (e.g. R script, python)

Quick Tips – Export data from Power BI using R 

Export data from Power BI to csv using Python 

Regards,

Xiaoxin Sheng

[amitchandak]

@jovendeluna21 , these two blogs discuss a different DAX append approach, see if that can help

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