cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
itchyeyeballs
Impactful Individual
Impactful Individual

Pipelines switch source workspace on deployment

Hi All,

 

I have looked through the docs but can't find an answer (I've probably missed something obvious)

 

We have 2 pipelines, the first is for the data model the second is for the visuals/analysis (is this the right way to set things up?).

When developing the reports they reside in the dev workspace for visuals and point at a dataset in the dev workspace for the data model.

 

When we deploy the report to test they continue to reference the dataset in the dev workspace, is there a way to get them to switch or do we have to manually change each time? I've looked at deployment rules but they only seem to apply to the dataset not the report.

1 ACCEPTED SOLUTION
Nimrod_Shalit
Power BI Team
Power BI Team

@itchyeyeballs,

You are correct that we don't have a good story for this use case yet.

We are working on a solution that will allow different pipelines 'just work' together, in the scenario you described.

 

As a temporary workaround, what you can do is connect the Prod dataset to all reports in 3 stages. Dataset changes can be evaluated in Dev /Test with local testing reports, so that when it is published to Prod, it is already tested.

 

HTH,

View solution in original post

3 REPLIES 3
itchyeyeballs
Impactful Individual
Impactful Individual

Hi @Nimrod_Shalit & @v-henryk-mstf  thank you for the responses, it's good to know it's being worked on!

I'll use the workaround as suggested

Phil

Nimrod_Shalit
Power BI Team
Power BI Team

@itchyeyeballs,

You are correct that we don't have a good story for this use case yet.

We are working on a solution that will allow different pipelines 'just work' together, in the scenario you described.

 

As a temporary workaround, what you can do is connect the Prod dataset to all reports in 3 stages. Dataset changes can be evaluated in Dev /Test with local testing reports, so that when it is published to Prod, it is already tested.

 

HTH,

v-henryk-mstf
Community Support
Community Support

Hi @itchyeyeballs ,

 

According to the information you provided, there is no problem with your development process. The correct way is to separate modeling development from report and dashboard development.  But this approach should start from Power BI Desktop, by creating a separate PBIX file for datasets and reports.

vhenrykmstf_0-1627019399257.png

 

We can set pipeline rule for dataflows, datasets and paginated reports. Not just for datasets.

vhenrykmstf_1-1627020021319.png

 

You can refer to the relevant official document link:

Get started using deployment pipelines, the Power BI Application lifecycle management (ALM) tool - P...

Best practices for deployment pipelines, the Power BI Application lifecycle management (ALM) tool - ...

 

Hope to help you solve the problem.


Best Regards,
Henry

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

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

Power BI Dev Camp Session 25 with aka link 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, August 25 at 11a PDT for a great session with Ted Pattison!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors