Forum Discussion
Deployment Pipelines and Azure Devops
- 5 years ago
I'll elaborate on jeffshieldsdev answer-
Since May, Power BI deployment pipelines have REST API that can be triggered from ADO pipelines and promote content through the stages in a Power BI pipeline. These APIs basically do the same operation that you can do through the UI of Power BI Service, but with all the value that ADO provides- scheduling dpeloyments, cascading multiple deployments, approvals, tests and many more.
What your colleagues asked about (i think) is why even use Power BI pipelines, when you can just use ADO pipelines and trigger regular Power BI REST APIs.
Well, there are quite a few advantages. to name some:
- Power BI pipelines allows for a holistic deployment of almost all the content in Power BI together, while REST API mostly support single artifacts that aren't related.
- In pipelines we also maintain the original connections between artifacts, as it was in the source stage. no need for 'rebind APIs'.
- Rules- PBI pipeline rules allow you to maintain connection and data to the target source, while with regular APIs you will need to set it after the import and refresh again, which causes downtime.
- Easier way to publish reports and datasets separately, even if you didn't separate them in the PBIX files.
- We are working now for APIs that will enable devs to build PBI pipelines from scratch, so that everything can be automated from scratch.
- 5 years ago
If you are using the same data source connection when working in Dev/ Test/ Prod, then there's no problem using 'Import API'. But if you want to switch connection between environments, as many customers do, this is where rules have the advantage vs. using the regular 'Import API'.
My understanding is you can use Azure DevOps to issue Deployment Pipeline commands via REST API. Your reports, datasets and dataflows still need to reside in development, test and production Workspaces--you can just use DevOps to promote between Workspaces.
I possibly didnt explain this clearly. The issue is that there is deployment pipelines in Power BI service, and You can also do those Deployment Pipelines in Devops. I think there has been some updates so you can actually create pipelines now in Devops.
Ive been questioned on the point of having deployment Pipelines in Service when you have DevOps.
I understgand that the objects are still in your workspaces in Service
1. If you have DevOps and can run the Deployment Pipelines in there, should you, or is there a case for using Deployment Pipelines in Service?
2. Is the Use case for the Deployment Pipelines in service when you dont have Devops?
3. Are the two very similar or is one better than the other?