Forum Discussion
How to automately download data sets or data Report
Hi everyone,
I recentely create a Power BI report based on several SQL data. This report is quite powerful in our day to day tasks but I would like to be able to perform a reporting based on the historicaldata of this report.
Each night the data sets of this report are updated and I consequentely loose the previous figures.
Ideally I would like to be able to automately download the data sets (or the report data) each night BEFORE the data sets are updated and ideally record the data into an Excel file.
Is this possible ? If yes, how ?
Many thanks,
Hi enzoperelli
I don't think this is possible if it is it's probably going to be a difficult and third party job as datasets were designed to be the endpoint data source.
if you need to keep the historic data you can explore incremental refresh
https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh
Dax studio can extract the data from datasets but I don't know if you can automate the process.
It would be easier to use SQL server to store the historic data, or set a job to output CSV or something.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
1 Reply
- Mariusz
Community Champion
Hi enzoperelli
I don't think this is possible if it is it's probably going to be a difficult and third party job as datasets were designed to be the endpoint data source.
if you need to keep the historic data you can explore incremental refresh
https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh
Dax studio can extract the data from datasets but I don't know if you can automate the process.
It would be easier to use SQL server to store the historic data, or set a job to output CSV or something.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn