Dynamically change dataset used in report

[Anonymous]

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 have one file that has the dataset, and another that has the reports.  It connects to this dataset.

Once I deploy this pipeline from test to prod, this report stops working because it is trying to connect to the dataset in test.  How can I fix this? I basically want to have one dataset and one report that connects to it.  When I deploy it, I would like that the report connects to the dataset in prod not test.

Any help here?

Regards,

Alen

[Anonymous]

My workspace has the following PBIX files published:

1. A file containing a dataset, and no reports.

2. Multiple files that fetch data from the dataset, creating different reports.

How can I publish the reports (that connect to the dataset in test) to production, and make it automatically link the the dataset on production.  I hope this is clear now.

[AbhiSSRS]

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]

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?