Forum Discussion
Scheduled data extract?
I've seen a few comments on this, but they all go back to using R which requires a personal gateway (which I can't) and they're all a few years old at least, so I'm hoping there's a new answer.
Is there a way to set up a daily extract, to csv/excel/sharepoint, of a Power Query-cleaned dataset?
I am linking directly to SAP BW and massaging the data in PowerBI for reporting. I'd like to take a daily snapshot and store it away.
Thanks,
Gregg
Hi greggbb ,
I’m sorry to tell you that using R is still the best method at present, you can refer to the article and video
https://www.youtube.com/watch?v=VmZUOcUD0qY
https://sqlitybi.com/auto-schedule-data-export-from-power-bi/
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi Gregg,
I'm not sure about completely automating currently but if Power Automate is an option and clicking a button is acceptable then give this video a look. https://www.youtube.com/watch?v=BnTipbooeP0&ab_channel=Curbal
Regards,
Kim
Thanks Kim, this is an interesting option as well.
Hi greggbb ,
I’m sorry to tell you that using R is still the best method at present, you can refer to the article and video
https://www.youtube.com/watch?v=VmZUOcUD0qY
https://sqlitybi.com/auto-schedule-data-export-from-power-bi/
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you!
