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?
We are using reports with live connection to datasets in another workspace - This is a major issue blocking us. We need to to be able to change the connection parameter from dev to test or test to prod when deploying these reports
What is the solution and when can we get it?
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...
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!
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?
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...
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...
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!