Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Advocate I
Advocate I

Managing embedded reports in multiple environments

We are working on a feature to embed a Power BI report within our proprietary application ("App-owns-data.")  We already have it working in that we can publish the report to the Power BI service wiht our Premium License and our application can fetch an embed token that allows it to display the report to our users with row-level security applied.  We are using the DirectQuery mode so that users can make changes in the app (ie purchase things) and see the report update in real time.


The problem is that like most development shops we have many environments.  In addition to our dev environments, there are 8 QA environments, UAT environments, Staging, Demo, Sandbox, etc. etc.  And we are planning to add more and more environments as we go.  Each environment of course has its own database and copy of the application.


My question is how are we supposed to manage our PBI report such that each environment is displaying the data from its database?  From what I can see, we essentially need to create a new workspace for each environment, and then we need to publish the report from PBI desktop to each one, changing the connection string each time.


This strikes me as absurd.  It means if I make a change to the report, I need to first publish it to the dev workspace, then I need to change the data source and publish it again to the QA1 workspace, change the data source, publish to the QA2 workspace, etc. etc. 30 times over! 


Surely there is a better, more automated approach for doing this, but I cannot find any reasonable suggestions online.  How do other dev shops manage this?

Advocate I
Advocate I

The process I described doesn't even work because if I change the connection and try to publish to a different workspace, it complains that the dataset already exists.  So different copies of the report in different workspaces need to use a common dataset?!


Hi @ryanjlind,


An App workspace is an independent collection of reports and dashboards. You need it in your scenario. How about creating a Content pack? You can create it in the My workspace and install it in other Apps. Finally, you just need to update the Content pack. Please refer to power-bi/service-organizational-content-pack-introduction.


Best Regards,


Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors