Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamically change dataset used in report

Hi All,   I am using deployment pipelines with two environment test and prod.   In test I have:  1. A dataset. 2. A report built on this dataset. These two are not in the same PBIX files.  I h...
Tutorial Requests
AbhiSSRS's avatar
AbhiSSRS
Icon for Solution Sage rankSolution Sage
5 years ago

When we deploy a live connected report the dataset gets deployed too along with that. So why are you facing any issue here? We can define deployment rules though in deployment settings here to change the source of Dataset from those of dev to respective environment. 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    OK, Let me try to explain this:

     

    1. Let's say I have a workspace, let's call it "Test Workspace". 

      a. This workspace contains one dataset and no reports at all. 

      b. This workspace is part of a deployment pipeline that contains one other workspace "Prod Workspace"

     

    2. I need to build a report that fetches data from the existing and published dataset.  So I start Power BI Desktop, connect to this dataset that is already published to "Test Workspace", and build a nice report.

     

    3. I publish the report created to "Test Workspace", business sees the report and they are happy with it and they approve it to go to "Prod Workspace"

     

    4. I go to the deployment pipeline, and I click "Deploy to Production" 

     

    Actual result:

    The pbix file containing the report is published, but it still connects to the dataset published on "Test Workspace" and not to "Prod Workspace" 

     

    Required result:

    I would expect that when I publish the report, it reconnects with the dataset published to "Prod Database"

     

    How can I achieve this?