Power BI Large Semantic Model Migration

A Jupyter notebook that automates the backup and restoration of Power BI large semantic models across different Capacity regions.

Overview

This notebook provides a streamlined workflow for migrating Power BI semantic models that use Premium Files storage mode. It handles the complete process of backing up models, migrating workspaces, and restoring data while preserving model functionality.

Prerequisites

• Workspace-level storage permissions enabled in Admin Portal
• Azure storage account linked to workspace/tenant
• Premium/Fabric capacity in source and destination regions

Workflow

1. Setup - Install dependencies and configure environment variables
2. Backup - Create compressed backups of large semantic models
3. Migrate - Move workspace to target Premium capacity
4. Restore - Restore models from backups with full functionality

Usage

1. Update the configuration variables with your specific Azure and Power BI details
2. Run notebook cells sequentially from top to bottom
3. Verify model functionality after completion

Important Notes

• Run cells in sequential order as each step depends on the previous one
• Allow time between storage format changes and restore operations
• Re-run setup cells if authentication session expires
• Review Microsoft's official backup/restore limitations before use