Authored by

Luca Gualtieri

8 min read

Share this article

PBI Lab is excited to announce that will present in next Virtual June 2020 Calgary Power Platform User Group meeting online. 

We can be found presenting on Tuesday, June 16th at 2:30 pm PT. Signup here

Join us to for a session on Power BI CI/CD with Azure DevOps.

You can check our GitHub repository for some PowerShell scripts, templates and slide deck.

We’ve embedded the  PowerPoint deck below, so feel free to flip through the slides.

Power BI CI/CD with Azure DevOps for Power Platform User Group

Session Outline:

In our daily business we can't wait for days, weeks, months or even longer to get our insights. We need to deliver faster!

Working agile to realize continuous delivery of results helps BI Teams to deliver artifacts to the end-user in a continuous flow; by continuously pushing new content to our end users, the chance for mistakes is growing exponentially.

To avoid mistakes, we can add some structure to our development and deployment processes. We can do this by working in a multi-tier process architecture. But how do we realize that with a self-service tooling like Power BI?

You might have heard about the acronym DTAP (Development, Testing, Acceptance, Production) and ALM (Application Lifecycle Management). These multi-tier developing processes are very common in software testing and deployment. However, in an upcoming industry of self-service IT, these processes are sometimes hard to use.

Power BI, which is mostly positioned and advertised by Microsoft as a self-service data analytics tooling, does not have a standard integrated capability to apply a multi-tier architecture for development and deployment.

You will leave this session with an understanding of how to deliver Power BI reports more regularly and more reliably, enabling you to respond better to your business demands. You will be able to use this session as a reference and enhance the solutions presented upon your business needs.

Session Format:

This is an advanced session which assumes a deep level of technical knowledge and experience and a detailed, thorough understanding of the topic.

In this session, Luca Gualtieri will provide expert-to-expert interaction and coverage of specialized topics.

Luca will kick things off by presenting a multi-tier developing process architecture for Power BI with a scenario built in his Power BI tenant. He will showcase options for version control and demo a deployment automation through Azure DevOps pipelines.

In this session Luca is going to discuss and demo different topics including:

  • New deployment pipeline (feature) preview
  • Setup of a multi-tier developing process architecture for Power BI
  • Version control for Power BI pbix files with Visual Studio and Azure DevOps Git
  • Azure DevOps CI/CD pipelines for Power BI workspace creation and report deployment
  • Power BI extension for Azure DevOps: Power BI Actions
  • Power BI Rest API and Power BI Cmdlets for PowerShell to automate the CI/CD in Azure DevOps

The event is powered by Power Platform User Group Calgary. The user group brings together users to share and enhance their knowledge of Microsoft's Power Platform and offer members the chance to collaborate on interesting ways to use the Power Platform. Each meeting features 3 to 4 demonstrations on using Power BI, Power Automate and PowerApps.

Join the Power Platform User Group


Our detailed articles, and technical white papers on the latest in BI news and technologies, curated and delivered to you via an editorial email newsletter.