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?
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?!
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.
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.