Power BI - Model Deployment Techniques & PowerShell for Power BI
20/01/2021
Jens Vestergaard (Catman Solutions)
Power BI – Data Model Deployment Techniques
In this session we will cover a variety of ways to deploy models both in pbix files as well as in Visual Studio projects. As there are a good number of ways to do this manually as well as automated, we will cover some of the more prevalent ones. The following methods will be covered:
• Visual Studio (manual)
• Tabular Editor (manual & automated)
• Deployment Wizard (manual & automated)
• Azure DevOps (automated) through
o Powershell
o TabularEditor
o Marketplace component
Aaron Nelson (Microsoft)
PowerShell for Power BI (and some Data Governance)
Power BI is designed as a user-friendly GUI based tool for creating and publishing beautiful reports. Unfortunately, it was not designed to integrate well with application lifecycle management or the DevOps methodology. For example, manually migrating the contents of one Power BI workspace to another workspace can be tedious and painful.
In this session, we will see how PowerShell will let us create environments for Dev, QA, and Prod in a reliable, repeatable way within the Power BI Service. We’ll then see how we can deploy an updated report from QA to Prod (with different data for each environment) without overwriting the Prod datasource.
In addition, we will discuss the Data Governance collection capabilities for easy and efficient auditing. By the end of this session, you’ll see how a few lines of PowerShell can save you time and frustration when dealing with Power BI Service workspaces.
Speakers
Jens performs the traditional BI disciplines from imports in Integration Services through data consolidation in Analysis Services, to report in Power BI or Reporting Services.
Jens has worked with The Stack since SQL 2000 and has a core competence in Integration Services and Analysis Services. Along with the certified skills in Microsoft SQL Server, Jens has also worked with Microsoft .Net platform for more than 15 years and currently manages a BI Platform in Azure for the CatMan Solution application(s).
Aaron Nelson is an award-winning author, public speaker, blogger, & leader in the SQL Server community. He has over 20 years of experience in architecture, business intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is an eight-time winner of the Microsoft MVP Award.
Aaron helps lead the PowerShell Virtual Group of PASS, helps run the GroupBy virtual conference, and is a volunteer at his local PASS chapter, AtlantaMDF.
Agenda (CET, UTC+1)
| 18u30 | Welcome and introductions |
| 18u45 | Power BI – Model Deployment Techniques (60 minutes) |
| 20u00 | PowerShell for Power BI (and some Data Governance) |
| 21u00 | Session End |
Location
Virtual Meeting (Teams Link)