Tired of manual deployments in Power BI? Say goodbye to repetitive tasks and hello to automation! In this post, I’ll walk you through how to streamline the release of Power BI development pipelines using Azure DevOps.
Tools & Technologies Used
- Azure DevOps Pipelines + extension Power Bi automation tools
- Power BI REST API for automating deployments
- Service Principal Authentication for secure access
First of all ensure you have all the components mentioned above.
We are going to create a new release pipeline.
For the template, we will select Empty job
Provide a name to the release pipeline and now we can define the tasks.
I am going to create the necessary variables and click on "Settable at release time", pipeline name and report name, but I will use the Id's.
This screenshot is an example in case you need to create a pipeline.
To deploy content between stages is neccesary to configure:
- PBI service connection
- Pipeline name/Id
- Target stage
The service connection in this example is configured with a service principal. The service principal should have access to the workspaces at least as member and also to the pipeline.
Configure the deployment task, complete with the pipeline name or Id.
We can also configure selective deployment or just deploy all. In this example I just want to deploy one report.
Create a new release.
Check if the release run succesfully.
If I check in the pipeline the last deployment date and the status of the report, I can easily verify that the deployment was succesfull.
🚀 Have you automated your Power BI releases? Share your thoughts or let me know if you need help setting it up! 💡 #PowerBI #AzureDevOps #Automation #CI/CD
Top comments (0)