Forum Discussion
Using Power Automate to backup .pbix files within same Powerbi.com workspace
- 1 year ago
Hi Felix4356 ,
Thank you for reaching out to Microsoft Fabric Community Forum.
Can you please try with the below possibilites and let us know if you need any assistance,
1) If your models are developed using Power BI Desktop and then published:
Save .pbix files in OneDrive or SharePoint.
Use deployment pipelines to manage and version reports.
Write a script (e.g., using PowerShell + Power BI REST API) to export the .pbix from your local/dev environment and back it up daily.2) Alternative Approach:
Prerequisites :
• Store the original `.pbix` file in a SharePoint document library
e.g., https://yourcompany.sharepoint.com/sites/PowerBI/Shared Documents/Master/SemanticModel.pbix
• Create a backup folder in SharePoint
e.g., https://yourcompany.sharepoint.com/sites/PowerBI/Shared Documents/Backups/
• Have access to Power Automate to create and manage flowsSteps to Create Daily PBIX Backup Flow :
Step 1: Create Scheduled Flow
• Open Power Automate
• Go to Create > Scheduled cloud flow
• Name the flow: Daily PBIX Backup
• Set:
- Start date and time (as per your preference)
- Repeat every 1 day
• Click CreateStep 2: Get PBIX File Content
• Click + New step
• Action: Get file content using path (from SharePoint)
• Configure:
- Site Address: https://yourcompany.sharepoint.com/sites/PowerBI
- File Path: /Shared Documents/Master/SemanticModel.pbixStep 3: Create Backup File
• Click + New step
• Action: Create file (from SharePoint)
• Configure:
- Site Address: Same as above
- Folder Path: /Shared Documents/Backups/
- File Name:
SemanticModel_@{formatDateTime(utcNow(),'yyyy-MM-dd')}.pbix
- File Content: Use output from previous step (Get file content)Attaching the similar link for your reference : https://community.fabric.microsoft.com/t5/Service/Backing-up-Power-BI-dataflows-as-json-file/m-p/4055781?utm_source=chatgpt.com
Regards,
Chaithanya.
out of curiosity why would you not be able import the data you require into power bi does it get overwritten in the source. It also depends on how big it is and what type of licensing you have as you are limited by space in your workspace, i also dont think saving it in the service is the most ideal backup strategy, there are times when files get corrupt. Most ideal would be to keep backups of your raw sourcce files so you could recreate the pbix.