Forum Discussion
How to Automate Export Power BI Report (.pbix) from Workspace to SharePoint
Hi. Let me start saying you can develop the pbix hosted at the sharepoint. That way all changes are in history version. Even better if you use a repository like github to keep track of all changes ever made for the pbix file.
If you really want to make backups, I would suggest this video: https://www.youtube.com/watch?v=RbMFQNthlGM
If you want to handle it by code, you can change the way the refreshes are run. Create a code to export the current report and then run refreshes with the Power Bi Rest API. This is the one for exporting: https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-report-in-group
You can use python library like simplepbi to make the export easier or just use any language code with coding skills. You probably can do that with Power Automate too.
I hope that helps,
data refresh and i want to save a copy as .pbix as backup in the sharepoint.
data refresh can be sheduled or done by powerautomate. but having the issue with exporting as .pbix file.
Super UserHi. Let me start saying you can develop the pbix hosted at the sharepoint. That way all changes are in history version. Even better if you use a repository like github to keep track of all changes ever made for the pbix file.
If you really want to make backups, I would suggest this video: https://www.youtube.com/watch?v=RbMFQNthlGM
If you want to handle it by code, you can change the way the refreshes are run. Create a code to export the current report and then run refreshes with the Power Bi Rest API. This is the one for exporting: https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-report-in-group
You can use python library like simplepbi to make the export easier or just use any language code with coding skills. You probably can do that with Power Automate too.
I hope that helps,