Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
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
@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/
User | Count |
---|---|
87 | |
72 | |
68 | |
64 | |
54 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |