Overview
Discover how to automate Power BI administration tasks and streamline your workflow in this comprehensive conference talk from PASS Data Community Summit. Learn to leverage CLI, PowerShell, and C# for automating common tasks, integrate Azure DevOps with Power BI for continuous integration, and create Power BI artifacts automatically. Explore topics such as Power BI REST APIs, Command Line Interface, PowerShell Cmdlets for Data Gateway, Deployment Pipelines, and External Tools. Gain insights into staged development approaches and the use of Power Automate to take your Power BI skills to the next level and increase efficiency in your organization.
Syllabus
Intro
Session Evaluation
Power BI done manually
Is it necessary to repeat the steps EVERY time?
Power BI and Automation - Tools
Power BI REST APIs REST API calls
Power BI CLI (Command Line Interface)
List all Workspaces
Create Workspace and Add User
PowerShell Cmdlets for Data Gateway Add a Gateway, Change configuration ...
Deployment Pipelines Staged Development Approach (Dev, Test, Prod)
Azure DevOps
Power Automate
External Tools
Taught by
PASS Data Community Summit