Solved: Re: Scheduled data extract?

greggbb · ‎09-23-2021

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

Anonymous · ‎09-27-2021

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.

View solution in original post

Anonymous · ‎09-27-2021

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 · ‎09-27-2021

Thank you!

KNP · ‎09-23-2021

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

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.