multiple workspace power bi deployment

[DiKi-I]

We are building multiple customer solution. Each customer has its own mirror db in workspace. How I can craete a template use it across multilple customer and do automatic parmeter binding for each workspace?

[tayloramy · Accepted solution]

Hi @DiKi-I,

You’re essentially describing a classic multi-tenant pattern in Power BI/Fabric: one “golden” solution reused across many customer workspaces, each bound to its own mirrored database. There are two solid ways to do this-one for cross-tenant distribution and one for many workspaces inside your tenant.

 

• If these customers are in other tenants: build a Template App and parameterize your connections. Each customer fills in their own server/DB (or Fabric item) at install. See Create template apps.
• If these customers are in your tenant (one workspace per customer): use a “golden” workspace + Deployment Pipeline rules (Parameter Rules, Data Source Rules, and Default Lakehouse Rules) to auto-bind each stage/workspace to the right mirror. See Create deployment rules and Get started with deployment pipelines.

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[v-echaithra · Accepted solution]

Hi @DiKi-I ,

A Power BI Template file (.PBIT) is a reusable report structure that allows for dynamic parameter values when the report is opened.

Steps:

Create the Power BI Report: Build a report in Power BI that includes dynamic parameters, such as customer ID, workspace ID, etc.

Define Parameters: Set up the parameters either in the Power Query Editor or Power BI Desktop, ensuring they can be adjusted as needed.

Save as .PBIT: Save the report as a .PBIT (Power BI Template) file. This template can then be programmatically modified to reflect the specific parameters for each customer, ensuring they see only their relevant data when the report is opened.

Reference: Create template apps in Power BI - Power BI | Microsoft Learn

Thank you.

[KevinChant · Accepted solution]

Hi, I highly recommend looking to work with the fabric-cicd Python library if you are looking to do the automatic rebinding when deploying to another workspace:

https://microsoft.github.io/fabric-cicd/0.1.29/

Here's a link to an example Git repository that you can use with a YAML pipeline in Azure DevOps that can help you get started:
https://github.com/kevchant/AzureDevOps-fabric-cicd-sample 

If this answers your question please give kudos and/or accept as solution.

[v-echaithra]

Hi @DiKi-I ,

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Best Regards,
Chaithra E.

[v-echaithra]

Hi @DiKi-I ,

I hope the information provided is helpful. I wanted to check whether you were able to resolve the issue with the provided solutions. Please let us know if you need any further assistance.

Thank you.

[v-echaithra · Accepted solution]

Hi @DiKi-I ,

A Power BI Template file (.PBIT) is a reusable report structure that allows for dynamic parameter values when the report is opened.

Steps:

Create the Power BI Report: Build a report in Power BI that includes dynamic parameters, such as customer ID, workspace ID, etc.

Define Parameters: Set up the parameters either in the Power Query Editor or Power BI Desktop, ensuring they can be adjusted as needed.

Save as .PBIT: Save the report as a .PBIT (Power BI Template) file. This template can then be programmatically modified to reflect the specific parameters for each customer, ensuring they see only their relevant data when the report is opened.

Reference: Create template apps in Power BI - Power BI | Microsoft Learn

Thank you.

[ribisht17]

Hi @DiKi-I 

Please check ...

1. Microsoft Fabric Community – Deploying Reports to Multiple Workspaces
   This thread discusses using Power BI REST API and deployment pipelines to automate report publishing and parameter updates across workspaces.
   Read the full discussion

2. Richard Swinbank – Working with Multiple Power BI Dataset Environments
   A deep dive into managing datasets and reports across environments using Azure DevOps pipelines and parameterized workflows.
   Explore the workflow and pipeline setup

3. Stack Overflow – Dynamic Dataset Binding in Embedded Power BI
   Explains how to use the Power BI REST API to generate tokens and dynamically bind datasets across workspaces.
   View the API usage and embed config

---

Regards,

Ritesh

Community Champion

Please mark the answer if helpful so that it can help others

Dance-Sing with Data -BI & Analytics

[tayloramy · Accepted solution]

Hi @DiKi-I,

You’re essentially describing a classic multi-tenant pattern in Power BI/Fabric: one “golden” solution reused across many customer workspaces, each bound to its own mirrored database. There are two solid ways to do this-one for cross-tenant distribution and one for many workspaces inside your tenant.

 

• If these customers are in other tenants: build a Template App and parameterize your connections. Each customer fills in their own server/DB (or Fabric item) at install. See Create template apps.
• If these customers are in your tenant (one workspace per customer): use a “golden” workspace + Deployment Pipeline rules (Parameter Rules, Data Source Rules, and Default Lakehouse Rules) to auto-bind each stage/workspace to the right mirror. See Create deployment rules and Get started with deployment pipelines.

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[DiKi-I]

The no of customers will grow in the future, so using deployment pipeline is not a feasible solution. Is there a way to autobind the power bi report parameter as per the customer workpsace?