How to Automate Export Power BI Report (.pbix) from Workspace to SharePoint

[abraham21]

Hi Community,

I am looking for guidance on how to automate export of a PowerBI report from workspace as a .pbix file into SharePoint.

Here are my specific questions:

1. How can I automate the export of the .pbix file from the workspace to a SharePoint folder?

2. Can this be achieved using Power Automate, Power Apps or any other way? If yes, could someone provide examples or steps?

[Thomaslleblanc]

https://www.fourmoo.com/2025/08/13/download-any-power-bi-report-from-the-power-bi-service/

[v-priyankata]

Hi @abraham21 

Thank you for reaching out to the Microsoft Fabric Forum Community.

@ibarrau @Thomaslleblanc Thanks for the all inputs.

I hope the information shared by the users was helpful. Did you have a chance to try those suggestions? If you still have questions, please don't hesitate to reach out to the community

[v-priyankata]

Hi @abraham21 

I wanted to check if you had the opportunity to review the information provided by users. Please feel free to contact us if you have any further questions.

[Thomaslleblanc]

I think the word refresh is confusing in your question.

Most refreshes are the data, not the report. 

Do you mean refresh the report structure and save a copy to sharepoint?

Or, are you asking to rfresh the data in the report, then make a backup of the data in the pbix file to sharepoint?

[abraham21]

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.

[ibarrau]

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,