Forum Discussion

ShijuKuchelan's avatar
ShijuKuchelan
Frequent Visitor
10 months ago
Solved

Deploy Master Semantic Model 2 Multiple Workspaces with Schema Change Using Microsoft Fabric Mirror

I have a source workspace that contains a master semantic model and reports. I want to automate the process of: Copying the semantic model and reports to multiple workspaces (around 1000). Updatin...
Interesting Links
Need Help
Tips and Tricks
  • v-karpurapud's avatar
    v-karpurapud
    10 months ago

    Hi ShijuKuchelan 


    Thank you for contacting the Microsoft Fabric Community Forum.

     

    As mentioned by GilbertQ , the recommended and industry-standard approach is to use a parameterized PBIT deployment together with the Update Parameters API. This is also the Microsoft-endorsed method for managing multi-workspace or multi-tenant Power BI environments.

     

    Create a master Power BI Template (.pbit) that includes your model relationships, measures, and visuals, along with parameters for key data-source elements such as Server, Database, Schema, or Tenant ID. These parameters allow each workspace to dynamically connect to the correct tenant data.

    Once the template is ready, use the Power BI REST APIs to automate deployment by importing the .pbit file into each workspace. After that, update the parameter values for each tenant as shown in the snapshot included in the provided  ,MS document.

     

     

    This method fully supports Delta Lake and Microsoft Fabric Mirror connections. You can update parameters like SchemaName for each workspace so it connects to the appropriate tenant schema within the mirrored database.
     

    In short, parameterized PBIT deployment with automated parameter updates is the most scalable, flexible, and Microsoft-supported solution for multi-tenant semantic model management in Power BI and Fabric.


     

    I hope this information is helpful. . If you have any further questions, please let us know. we can assist you further.

     

    Regards,

    Microsoft Fabric Community Support Team.
     

ShijuKuchelan's avatar
ShijuKuchelan
Frequent Visitor
10 months ago
v-karpurapud  GilbertQ 
I created a semantic model in a source workspace (connected to Delta Lake via Fabric). Then, using Power BI Desktop, I built a report and saved it as a .pbit file.
I programmatically imported the .pbit into a target workspace using the Power BI Import API: POST https://api.powerbi.com/v1.0/myorg/groups/${workspaceId}/imports
 
The report was successfully imported into the target workspace, but it still logically points to the semantic model in the source workspace, which breaks the isolation between environments.
I'm not sure how to update parameters like SchemaName in the semantic model definition.So as a workaround, I followed the approach below.
 
1. Export model using POST /v1/workspaces/semanticModels/{id}/getDefinition
1.1Parse TMDL and extract OneLake connection details:
├─ Workspace ID: xxx-xxx-xx-xx-xxxx
├─ Item ID (Lakehouse): xxx-xx-xx-xx-xxx
└─ Found in: definition/expressions.tmdl
 
1.2Identify DirectLake configuration
 
 ├─ Mode: directLake
├─ Schema: TENANT_1
├─ Expression Source: DirectLake - DB_NAME
└─ Found in: definition/tables/test.tmdl
 
1.3 Replace tenant-specific schema names 
 
1.4 Re-encode and create semantic model in target workspace using POST /v1/workspaces/{id}/semanticModels
 
 
2.PBIT Import
validate and upload .pbit using /imports API
 
3.Report Rebinding
   Use POST /reports/{id}/Rebind to point report to new semantic model
   
4.Semantic Model Refresh
Trigger DirectLake refresh via /datasets/{id}/refreshes
 
 
Can you provide a step-by-step guide to update parameters such as SchemaName and DirectLake via fabric or powerBI desktop ?
Is this a valid workaround for migrating reports and semantic models between Fabric workspaces? 
Are there best practices for handling OneLake connections and schema transformations in TMDL?