Forum Discussion
Disaster Recovery considerations for Power BI Embedded Capacity
Hello,
We use Power BI Embedded and Fabric capacities and are considering disaster recovery possibilities for the same. We have the option to reassign the Power BI Workspace to another capacity in different region when the region of initial capacity is in outage. We need to know if this is possible.
If direct answers are not available, then it will help to know which region the Power BI reports (with data), Semantic Models, Bookmarks, etc. are stored when a workspace is assigned to Power BI Embedded or Fabric capacity which are created in specific regions.
I have seen some documentations which mention the Azure resources (Blob storage, Azure SQL, etc.) used to store different artefacts, but these do not say anything about the region where the artefacts are stored.
TIA.
Hi Shagil_I -Unfortunately, Power BI does not natively support automatic region-level replication of items (like models, query cache, R images) in Embedded capacities. Power BI Embedded is tied to the region where the capacity is created, and as such, the items stored in a workspace associated with a specific capacity are typically located in the same Azure region.
These are stored in the region tied to the capacity and are not automatically replicated to another region for read access in case of an outage.
If a region goes down, manual intervention is required to move the workspace to another capacity in a different region. This process would involve reassigning workspaces to the failover region’s capacity. For semantic models, especially large ones, this can be complex since they would not automatically move and might require redeployment.
To ensure continuity during an outage, you may need to set up backup/replication strategies for datasets and models manually and have a failover plan that includes reassigning workspaces or redeploying large models in another region.
Ref links:
Multi-Geo support for Fabric - Microsoft Fabric | Microsoft Learn
Power BI high availability, failover, and disaster recovery FAQ - Power BI | Microsoft Learn
3 Replies
- rajendraongole1Super User
Hi Shagil_I -Power BI allows for workspaces to be moved between capacities, but moving to a capacity in a different region may not always provide immediate disaster recovery. While you can reassign a Power BI workspace to another capacity in a different region, the actual data (reports, models, datasets) remains tied to the original region where the workspace was created. For full disaster recovery, additional steps such as replicating data or utilizing Azure's geo-redundancy options would be necessary.
Ref links:
Microsoft Fabric disaster recovery experience specific guidance - Microsoft Fabric | Microsoft Learn
Power BI high availability, failover, and disaster recovery FAQ - Power BI | Microsoft Learn
Public Preview of Multi-Geo for Power BI Premium | Blog di Microsoft Power BI | Microsoft Power BI
Multi-Geo support for Fabric - Microsoft Fabric | Microsoft Learn
- Shagil_IFrequent Visitor
Hi rajendraongole1,
Thanks for your response.Our use case is to ensure data refresh and report accessibility when the region of Capacity is in outage, assuming all Azure services in this region are down; but services in Power BI home region remain available.
When you're using Multi-Geo, the following items are stored in the region that isn't your home region: - Models (.ABF files) for import and DirectQuery semantic models - Query cache - R imagesFrom this, i understand that in our use case, as rest of the items are in home region, we only need to consider how to bring these items in the region of the target capacity (in same geographic area).
From the same page, it also appears to say that when a capacity is changed to one in a new region, the items are copied to new region.
When moving data from one region to another, the source data might remain in the region from which the data was moved for up to 30 days. During that time end users don't have access to it. The data is removed from this region and destroyed during the 30-day period.Also, here it says that large semantic models cannot be moved to new regions, so, i assume that small semantic models can be moved to other regions.
It's possible to create and maintain large-storage format semantic models in remote regions to meet data residency requirements. However, you can't move storage format semantic models to another region. Moving large-storage format semantic models from the region where they were created results in reports failing to load the semantic model. Move the large-storage semantic model back to its original region to make it available. If you must move such a model, deploy it as if it was a new model, and then delete the old model from the undesired region.So, the questions is mainly to know whether there is a region level replication of the items (Models, Query cache, R images, as mentioned above) for Power BI Embedded ensuring, at least, read access (to allow copy) of these items to another region in case of a disaster.
What we are looking for is similar to as described here for Power BI items: https://learn.microsoft.com/en-us/fabric/security/experience-specific-guidance#sample-scenario. This page is for specific Fabric items. Does this also apply to Power BI Semantic Models, and other items in a Power BI Workspace associated with Embedded Capacity?
- rajendraongole1Super User
Hi Shagil_I -Unfortunately, Power BI does not natively support automatic region-level replication of items (like models, query cache, R images) in Embedded capacities. Power BI Embedded is tied to the region where the capacity is created, and as such, the items stored in a workspace associated with a specific capacity are typically located in the same Azure region.
These are stored in the region tied to the capacity and are not automatically replicated to another region for read access in case of an outage.
If a region goes down, manual intervention is required to move the workspace to another capacity in a different region. This process would involve reassigning workspaces to the failover region’s capacity. For semantic models, especially large ones, this can be complex since they would not automatically move and might require redeployment.
To ensure continuity during an outage, you may need to set up backup/replication strategies for datasets and models manually and have a failover plan that includes reassigning workspaces or redeploying large models in another region.
Ref links:
Multi-Geo support for Fabric - Microsoft Fabric | Microsoft Learn
Power BI high availability, failover, and disaster recovery FAQ - Power BI | Microsoft Learn