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.
Latest posts by Aaron Nelson (see all)
- PowerShell for Power BI (and some ETL) - August 30, 2019
- Azure Data Studio ❤ SQL People - August 30, 2019
- Introduction to SQL PowerShell (the awesome new 2016 version)! - January 20, 2017