Scheduled data extract?

[greggbb]

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

[v-stephen-msft · Accepted solution]

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.

[greggbb]

Thank you!

[KNP]

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

[greggbb]

Thanks Kim, this is an interesting option as well.