Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Power BI Deployment to multiple target workspaces

Hello, We have one Dev & and Test ( stage) workspace and multiple production workspaces. We want to create seperate pipelines to deploy from single dev/test to different production workspaces. Do  we know if single source workspace can  deploy to different targets workspaces.

 

Based on the document it seems a workspace can only be assiged to a single deployment pipeline. if current pipeline has a limitation, Is there any other alternative to do this as we don't want to avoid manual migration to production. 

 

Thanks.  

 

19 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    We have the same issue here. Hoping for One DEV & UAT to Many Production workspaces but seems like it's impossible. I wonder if we can upvote this so the PBI team will push this feature in the future.

  • Hi Anonymous,

    This is not possible today in deployment pipelines. Some follow-up quesitons here:

    - How many Prod WSs do you have?

    - If they were serialized in the same pipeline, would that work for you as well? e.g you might have 10 stages in the same pipeline, 8 of them are Prod, and you just deploy between them one after the other.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello Nimrod_Shalit

       

      Does it mean that I can add in the Prod stage multiple Prod workspaces? 

      Ideal is to have 1 Dev, 1 Test and 2 or more Prod stage linked to Test stage, so after testing we can decide which workspace assigned. 

      Sequential Prod space would work, but still the first option will work better. 

      Is it something the PowerBI team working on, would be it possible in the near future?

      Thanks a lot

      Valeria 

    • timmyc1's avatar
      timmyc1
      Regular Visitor

      Our use case is more based on keeping data in the same region - so we have global ISV organization and have reports based on data from clients in the UK and reports from clients' data in the US.  We can build those reports in either region with test data for the 'Dev' and 'Test' workspaces, but then we wanted to have a fork where we can deploy to a 'Prod_UKS' or 'Prod_CUS' workspace because that production version would use client data that needs to be kept in the respective region.

       

      The ideal design would be one dev, one test, and two prod where we could pick the content based on the target workspace.  Alternatively, a linear deployment path could work if we could skip a stage - so each prod workspace would show as a different stage, but we'd have to be able to skip the first 'Prod' environment if content was only supposed to go to the second 'Prod' environment.  


      I assume it's a pretty common requirement for especially for software vendors where client data has to stay in the same region that the client resides in.

       

      Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable

    Nimrod_Shalit, we have same requirement too. We have organized our reports in such a way in order to control access to users. Is there any workaround for this ?

  • LeeBenjamin's avatar
    LeeBenjamin
    Microsoft Employee

    Hi
    In case you're using multiple Prod environments just to seperate content to different audiences, you may find our Apps new feature as a proper solution. It is now possible to create an app to your single Prod environment workpace, and then assign each dashboard of this ws to different views (audiences) in your app. Learn more about this solution here:
    Announcing Public Preview of Multiple Audiences for Power BI Apps | Microsoft Power BI Blog

     

    Lee

    • dellrio's avatar
      dellrio
      New Member

      We use the apps for report consuption of our content at our company, and the multiple audiences was a huge benefit to us, however we have use cases where we would need as many as 30 unique audiences, and currently have a limit of 10.  This requires multiple apps, and multiple workspaces with multiple prod only deployments from the same Dev/Test workspaces.   Do you expect the limit of 10 audiences will ever be increased?

      • LeeBenjamin's avatar
        LeeBenjamin
        Microsoft Employee

        Hi dellrio,
        I'm not sure of PBI Apps future plans and I suggest you'll post an idea asking for it on the Ideas portal.
        Other than that, as a workaround, Deployment pipelines will launch this month the option to build a deployment pipeline of more than 3 stages (allows 2-10 stages). With that, you'll be able to create a 5 stages pipeline: dev-test-prod1-prod2-prod3 and link each one of the prods to an app. Please advise that once you you create the pipeline, you can't add more stages, so if you believe you'll have more audiences in the future, I'd create another prod stage (prod4) and keep it empty to the day it will be required. I hope that helps.
        BR,

        Lee