Skip to content

Backup

Does Microsoft back up Power BI? How to protect reports and models

Your data warehouse is probably backed up. The semantic models, reports and gateway settings built on top of it often aren't.

Night-time office desk with a dashboard fading from a monitor and a small gateway server glowing beneath the desk

The short answer

Not in a way you can restore from yourself. Microsoft replicates the Power BI service for its own disaster recovery, and admins can restore a deleted workspace within a 7 to 90 day window. There's no self-service point-in-time restore for an overwritten report or semantic model, so you need exported definitions, protected sources and documented gateways.

Key takeaways

  • Microsoft's Power BI replication exists for Microsoft's own failover after a regional outage, not for restoring content you deleted or overwrote.
  • A deleted collaborative workspace is kept for 7 days by default, configurable up to 90 days; a deleted My workspace is kept for 30 days.
  • Semantic model backup to Azure Data Lake Storage Gen2 is available on Premium and Premium Per User capacity only, and it doesn't include reports.
  • Saving reports as Power BI Projects (PBIP) in Git gives you versioned, restorable definitions of both report and model.
  • Keep the gateway recovery key safe: Microsoft states it can't retrieve the key if you lose it.

What does a Power BI backup actually need to cover?

A recoverable Power BI environment covers four layers, not one. If your plan only protects the source databases, the work your analysts built on top of them is unprotected.

Picture a finance team on Monday morning. A clean-up script removed a workspace on Friday, and with it the semantic models, reports and months of curated measures. The source databases are fine, but nobody knows when the reports were last exported. This is a common blind spot, and it's why we look at analytics as part of a wider backup as a service plan rather than a platform someone else protects.

  1. Source data. SQL Server, files, ERP and cloud databases, on-premises or in Azure. Usually the best-protected layer.
  2. Semantic models. The relationships, measures and transformations built in Power BI. Often they exist nowhere else.
  3. Reports and dashboards. The .pbix or PBIP definitions, recoverable only if exported and versioned.
  4. Gateways and configuration. On-premises data gateway settings, data source credentials, refresh schedules and workspace permissions.

Losing layer 1 means a database restore. Losing layers 2 to 4 usually means rebuilding by hand.

Does Microsoft back up your Power BI environment?

Microsoft keeps backup instances of the service for its own continuity, but that isn't a backup you can restore from. Recovering your content after deletion or corruption is your responsibility.

Microsoft's Power BI high availability and disaster recovery FAQ explains that service components sync their backup instances with "a 15-minute targeted point-in-time sync", using geo-redundant replication in paired regions. That design exists so Microsoft can fail the service over after a regional outage, a decision its operations team takes. It doesn't give you a button to roll back a model to last Tuesday.

The wider principle comes from Microsoft's own shared responsibility in the cloud page: regardless of deployment type, you always retain responsibility for your data, endpoints, accounts and access management. Power BI, as a SaaS service, is no exception. We explain the model in more depth in the Microsoft 365 shared responsibility model, and the same logic is behind why Microsoft 365 doesn't back up your data.

What native recovery options does Power BI have?

There are useful native options, but each covers one layer and has clear limits. Combined, they still leave gaps for overwritten content and anything older than the retention window.

Native optionWhat it coversLimits
Workspace retentionRestoring a deleted collaborative workspace7 days by default, configurable from 7 to 90 days; Tenant Admin only
My workspace retentionRestoring a deleted personal workspaceFixed at 30 days
Semantic model backup and restoreSemantic models as .abf files in Azure Data Lake Storage Gen2Premium or Premium Per User capacity; XMLA tools only; no reports
Power BI Projects (PBIP) in GitReport and model definitions as text files with version historyMust be adopted by authors; doesn't include data or gateway settings
Gateway recovery keyRestoring or migrating an on-premises data gatewayOnly works if you stored the key; Microsoft can't retrieve it

According to Microsoft's workspace retention documentation, after the retention period "Fabric permanently deletes the deleted workspace and its contents". It also warns that shortening the retention setting can permanently delete workspaces that have already passed the new value, with no grace period.

The semantic model backup and restore feature requires Premium or PPU capacity and an ADLS Gen2 account Power BI can reach directly, and there's no backup option in the Power BI user interface. Power BI Desktop projects save report and semantic model definitions "as individual plain text files", designed for Git, which makes them the most practical way to version reports. For the gateway, Microsoft's gateway restore guidance is blunt: "Microsoft doesn't have access to this key and it can't be retrieved by us."

What extra risks does a hybrid Power BI setup add?

Hybrid setups split ownership. The cloud team owns workspaces, the infrastructure team owns gateways and databases, and nobody owns the full recovery path.

  • Gateway servers. The on-premises data gateway runs on a server you manage. Lose the VM and the recovery key, and every scheduled refresh stops.
  • Personal workspaces. Production reports that live in a leaver's My workspace disappear with the account once the 30-day window passes.
  • Overwrites, not deletions. A model republished with a broken measure isn't deleted, so workspace retention doesn't help at all.
  • Compliance evidence. GDPR Article 32(1)(c) requires "the ability to restore the availability and access to personal data in a timely manner", and NIS2 Article 21(2)(c) names backup management and disaster recovery among the required measures. "We think we could rebuild it" won't satisfy an auditor.

How do you make Power BI recoverable?

Protect each layer with the right tool, then prove it works. Five steps cover most environments.

  1. Classify what matters. Inventory workspaces, flag the reports and models decisions depend on, and move production content out of My workspaces.
  2. Version report definitions. Save critical reports as PBIP and commit them to Git, or export .pbix files on a schedule to protected storage.
  3. Back up the sources. Make sure every database and file share behind your gateways has an immutable, off-site backup that follows the 3-2-1-1-0 rule.
  4. Document the gateway. Store the recovery key in a password vault, back up the gateway server, and record data sources, credentials owners and refresh schedules.
  5. Test the restore. Rebuild one model and report in a test workspace from your copies each quarter, time it, and keep the record. Our guide on how to verify your backup works covers what to measure.

If you run Premium or PPU, add semantic model backups to ADLS Gen2 for large models that take hours to refresh. Raise workspace retention to the maximum 90 days while you're in the admin portal.

Where does Mindtime fit in a Power BI recovery plan?

We don't back up the Power BI service itself. We protect the layers underneath and around it, which is where most of the rebuild effort sits.

  • Source databases: our SQL Server database backup protects the data your models refresh from.
  • Gateway servers: a gateway VM on VMware or Hyper-V is covered by our VMware and Hyper-V backup, with granular restore.
  • Exported definitions: PBIP folders or .pbix exports stored in SharePoint or OneDrive are files like any other, protected by our Microsoft 365 backup.
  • Azure sources: workloads in Azure can be included through our Azure backup.

All copies are stored only in our own Tier III data centres in the Netherlands and Germany, immutable with Object Lock plus an air-gapped copy, with every backup job checked automatically.

What to do next

Power BI rarely fails through an outage. It fails through a deleted workspace, an overwritten model or a gateway nobody documented. Because Microsoft's role ends at running the service, recovering your analytics layer is a job you have to plan: versioned definitions, protected sources, a documented gateway and restore tests you can show an auditor.

Start with the cheapest fix: find your gateway recovery key today, and raise workspace retention to 90 days. Then check how your sources and exports fit into your backup as a service setup.

Not sure which layers of your Power BI estate are recoverable? Ask us for a free assessment and we'll map what's protected and what isn't.

This article is information, not legal advice.

Frequently asked questions

Does Microsoft automatically back up Power BI reports?

Microsoft replicates the Power BI service so it can fail over after a regional outage, but it doesn't give you a self-service restore point for a report or semantic model you overwrote. Admins can restore a deleted workspace within the retention window, 7 to 90 days. Long-term, versioned copies of your content are your responsibility.

How do I restore a deleted Power BI workspace?

A Fabric or Power BI tenant administrator can restore a deleted collaborative workspace from the admin portal's workspace page within the retention period, which is 7 days by default and configurable up to 90 days. Deleted My workspaces are kept for 30 days. After that, Microsoft permanently deletes the workspace and everything in it.

Can I back up a Power BI semantic model?

Yes, if the model sits on Power BI Premium or Premium Per User capacity. You connect a workspace to Azure Data Lake Storage Gen2 and use XMLA-based tools such as SQL Server Management Studio to create .abf backup files. There's no option in the Power BI interface, and the feature covers semantic models only, not reports.

What is the best way to version Power BI reports?

Save reports as Power BI Projects (PBIP). PBIP stores report and semantic model definitions as plain text files in a folder structure designed for Git, so every change gets version history and you can restore or compare any previous state. Store the repository, or regular .pbix exports, somewhere that is itself backed up.

What happens if I lose the on-premises data gateway recovery key?

You can't restore, migrate or take over that gateway, and Microsoft can't retrieve the key for you. You'd need to install a new gateway and reconfigure every data source and its credentials. Store the key in a password vault when you install the gateway, and back up the server it runs on.

Sources

  1. Set up and manage workspace retentionMicrosoft Learn, 2026
  2. Power BI high availability, failover, and disaster recovery FAQMicrosoft Learn, 2026
  3. How to back up and restore Power BI Premium semantic modelsMicrosoft Learn, 2026
  4. Power BI Desktop projects (PBIP)Microsoft Learn, 2026
  5. Migrate, restore, or take over an on-premises data gatewayMicrosoft Learn, 2025
  6. Shared responsibility in the cloudMicrosoft Learn, 2026
  7. Regulation (EU) 2016/679 (GDPR)EUR-Lex, 2016
  8. Directive (EU) 2022/2555 (NIS2)EUR-Lex, 2022
Part ofBackup as a Service