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,

View solution in original post

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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!