PowerShell for Power BI (and some ETL)

Target Audience:

Power BI Developers & Workspace Curators


Power BI is design 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 dynamically create a Power BI dataset and publish the data to the Power BI Service. Based on this we’ll see how to create environments for Dev, QA, and Prod in a reliable, repeatable way. We’ll also see how we can support multi-tenant solutions and reuse the same report with different data for each customer.

By the end of this session you’ll see how PowerShell can outperform manual GUI tasks in PowerShell, and how to create a repeatable deployment process.

Why I Want to Present This Session:

Common problems in Power BI can be automated with the existing cmdlets, but not many customers even know about them.

Additional Resources:

The following two tabs change content below.
Aaron Nelson is a Consultant with SolidQ with over 15 years of experience in Architecture, Business Intelligence, Development, and Performance Tuning of SQL Server. He was recently awarded a 6th Microsoft MVP for SQL Server (Data Platform). Aaron holds certifications for MCITP: Business Intelligence Developer, Database Administrator, & Database Developer. Aaron leads the PowerShell Virtual Chapters of PASS, and volunteers for the local PASS Chapter AtlantaMDF, and helps organize SQL Saturday events in Atlanta.
Previous Post
Azure Data Studio ❤ SQL People
Next Post
Tips and Tricks of a Power BI (Premium) Implementation at a Financial Institute

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.