This section provides scripts and accelerators to modernize and upgrade a Power BI datamart into a Microsoft Fabric data warehouse, enhancing performance with Direct Lake semantic models and improved creator experiences.
This section offers accelerators designed to assist you in upgrading and modernizing to a Fabric data warehouse. The resources provided include:
- Schema and table creation: Script for creating the schema and table, includes data type compatibility conversion between a datamart and a data warehouse.
- Power BI semantic model migration: Automatatic modernization of existing Power BI semantic models built from a datamart to Direct Lake models on top of the Fabric Data Warehouse, includes rebinding of reports.
- To get started, use the schema and table creation PowerShell script.
- This script prompts will guide you through the process of completing the following required input fields.
| Name | Description |
|---|---|
| Datamart Server Address | How to retireve the SQL connection string for the Fabric datamart. |
| Datamart Name | The datamart name as it is displayed in the workspace list. |
| Datawarehouse Server Address | How to retrieve the SQL connection string for the Fabric data warehouse. |
| Datawarehouse Name | The data warehouse name as it is displayed in the workspace list. |
| Schema Name | The name of a new schema that will be created in the data warehouse. |
| Tenant Id | The customer tenant id (CTID) is appended to the end of the tenant URL, you can find the CTID in the Fabric portal by opening the About Microsoft Fabric dialog window. It's available from the Help & Support (?) menu, which is located at the top-right of the Fabric portal. |
- Download and import the Power BI semantic model migration notebook into a workspace.
- Within the Import the library and set initial parameters code block, complete the following input parameter values as described below.
| Name | Description |
|---|---|
| workspace_name | Specify the workspace of the datamart semantic model. If set to None, it will use the current workspace. |
| dataset_name | Specify the name of the datamart semantic model. |
| new_dataset_name | Specify the name for the new Direct Lake semantic model. |
| item_name | Specify the name of the warehouse to be used for the Direct Lake semantic model. |
| item_type | Specify the item type for the migration; options are 'Warehouse' or 'Lakehouse'. Important: Ensure that it is configured as 'Warehouse' |
| schema_name | Specify the name of the schema from the data warehouse. Important: Ensure that it is configured to match the Schema Name from the previously executed script. |
Data ingestion from the original datamart is not migrated in this solution - as it is now decoupled, allowing you greater flexibility of options across Microsoft Fabric - including the use of standalone items such as dataflow gen2, data pipelines, copy job and more. If you wish to continue to use the Power Query Online authoring experience you can export a Power Query template which includes your original queries and transformation logic and create a new dataflow gen2 to ingest data.