Skip to content

Latest commit

 

History

History

PowerShell-for-PowerBI

PowerShell for Power BI

These are the latest scripts & Notebooks used in my presentation

Abstract

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

Demos