Forum Discussion

Gerelyn67's avatar
Gerelyn67
New Member
5 months ago

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

  • 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 .pbix files 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

     

  • 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!

     

     

  • Do you mean for the metadata of the reports or all the data stored in Fabric? Because various options available depending on which.

  • 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