Forum Discussion
Daily Download report from workspace
Hello! Does any of you figured out a way to somehow download report and/or dataset automaitically from PowerBi workspace on daily basis ?
I have checked the powerAutomate, but unfortunately it does not containt that funcuonality.
Any tips appreciated 🙂
2 Replies
Hi. The only thing you can do is write a script with any programing language or I think Automate premium would be able to do it too. The idea is using the Power Bi Rest API to Export Report as Pbix. There limitations on the request so be sure to read the docs before starting the code: https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-report-in-group
You can make it easier with some libraries like SimplePBI for python or the PowerBi cmdlets for powershell.
That's the only way to auto download a report from PowerBi that I know.
I hope that helps,
Thanks, this is what i have expected unfortunately.....
