Forum Discussion
Power BI Backup solution
Do you know a good Power BI Backup solution for our customer?
Our preference leans toward a SaaS solution.
Thanks
5 Replies
- AntoineWSuper User
There is no native "one-click" back-up for individual power bi reports.
Some strategies I see are:
-
use Version Control : you can switch your .pbix file to .pbip (Power BI Project) files and using Git or Azure DevOps integration. This helps you track all changes and rolling back.
-
Cloud Storage: You can also save your
.pbixfiles to a SharePoint or OneDrive to leverage their built-in version history. It's easy way but it's more complexe to maintain when you have version_1, ..., version_finale... but it's an option if you want to keep all history of the evolution of your reporting. -
Manual/Scripted Backups: Some teams use Python scripts or Power BI REST APIs to automatically copy reports to a Data Lake.
I found a discussion about that : https://www.reddit.com/r/PowerBI/comments/1l1kn1j/what_is_your_backup_strategy_for_power_bi_report/
Hope it can help you !
Best regards,
Antoine
-
- svenchioSuper User
Hi Gerelyn67 I think this needs to be split into two perspectives:
#1. Report & semantic model design. Backup my DEFINITION (e.g. report's design, visuals configurations ) and the semantic model schema (e.g. tables, relations, etc.)
#2. Report & data. I have a Power BI report (s) in its PBIX with data loaded that I want to back up right after we push of data.
If you are looking for a third-Party Power BI Management Product, the only one I know that seems like what you are asking for is https://www.powerbisentinel.com/ "Discover how Power BI Sentinel can elevate your organization's data governance and security strategy." welcome to give it a try.
I'm going to assume you want a "do-it-our-selves" solution and need advise on the alternatives 😉 and in this context, I think the resources shared by AntoineW are perfect for #1. Report & semantic model design, the idea is for you to move away from PBIX version of your reports and make them Power BI projects and the code version controlled via Git, this way, the code is you backup! You can recreate your Report's design any point in time you need via commits, branches, tags, etc. (git version control theory is out of the scope for this short answer)... but this requires yes, that you migrate your reports to Fabric with its implications in terms of work, costs, etc.
As suggested by AntoineW with Cloud Storage & Manual/Scripted Backups are for #2. Report & data, that is juust want to keep your existing PBIX reports and have them backed up & secure, both alternatives as suggested are good, BUT I STRONGLY SUGGEST YOU TO MOVE AWAY FROM PBIX AS SOON AS POSSIBLE! And this seems to be the perfect opportunity to do it and argument in favor of moving your reporting infrastrcuture to Fabric because all the benefits associated with SaaS solutions.
Ufff, rather long answer but I hope further clarifies and helps with your decision, if it does, give us a kudos! and mark as solution if appropiate... all the best!
- svenchioSuper User
Gerelyn67 I just published on my blog a whole series on the topic of Fabric with the perpective of Power BI reports if interested CI/CD workflow for Fabric & Power BI fully automated! (Series)
- KevinChantSuper User
Do you mean for the metadata of the reports or all the data stored in Fabric? Because various options available depending on which.
- jp_golayHelper III
We use a tool called Active Backup, available from Ebiexperts. We connected the SaaS to our PBI in minutes, and each time I save any Fabric Item (Reports, SM, Notebook....) I get an auto backup that I can recover. Very efficient even in huge infrastructure and no manual process