cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mitchvdd
Frequent Visitor

Deployment Pipelines -Datasource rules for Power BI Report with the connection to a Power BI Dataset

I am currently investigating to use Deployment Pipelines for the deployement of Power BI Reports. These reports have a live connection with a Power BI Dataset which is placed in a separate workspace (as the best practices of Power BI describe). Unfortunately I am not able to set any datasource rules for these reports in the Deployment Pipeline. I would like to connect the reports in DEV, with DEV dataset, etc.

 

Is this currently possible?

9 REPLIES 9
Nimrod_Shalit
Power BI Team
Power BI Team

@RedYsl , @Mitchvdd @juancho182 , @lbendlin 

multiple pipelines support is now live!

read more about it in our blog announcement- Deployment pipelines- Azure DevOps extension, multiple pipelines working together, Dataflows GA | Mi...

AbhiSSRS
Super User
Super User

This works for paginated reports live connected to datasets or SSAS but doesn't work with live connected pbix! 
Also noted a security issue with paginated Datasource transformation showing actual V-address of server in cloud!

Correct that this is still not possible for pbix reports...

Nimrod_Shalit
Power BI Team
Power BI Team

@Mitchvdd,

unfortunatley, this is still not possible yet.

We are planning to close this gap by the end of the year.

In the meantime, a possible workaround would be to set all reports to connect to the PROD dataset, and have local reports within the dataset pipeline, where you can test changes in the datasets. 

Another option is not to manage the dataset in a pipeline, and use it for reports only.

Hi @Nimrod_Shalit as we are in Q4 now, any updates on this topic? Can I use deployment pipelines to point live connections to DEV, QA and PROD respectively?

 

Thanks,

I'm happy that this is a gap you would like to close, but until this is possible I'm unable to use the Deployment Pipelines (which I personally am a big fan of!). However, it works very well for Power BI Dataset in combination with datasource rules. 

 

When you have local reports within the workspaces connected to another datasource it's not possible the push a report from DEV to ACC with Deployment Pipelines. So the problem is not with datasets, but with reports...

lbendlin
Super User
Super User

yes, that's how it is designed. Have you used the dataset parameters?  If yes, where are you stuck?

RedYsl
Frequent Visitor

As far as I kown, for reports based on Live Connection Dataset we don't have access to the connection string where we can add parameters.

Waiting desperatly for March releae : https://docs.microsoft.com/en-us/power-platform-release-plan/2021wave2/power-bi/deployment-pipelines...

 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

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