10-16-2020 08:36 AM - last edited 10-16-2020 09:59 AM
In this Microsoft Power BI Dev Camp session, we'll explore how to get started with writing and testing PowerShell scripts to automate common administrative tasks in a Power BI environment. We'll begin by introducing the Power BI Cmdlets library and discussing the various ways to authenticate as either a user or as a service principal. Campers will learn how to automate common tasks such as uploading PBIX files, patching data source credentials and refreshing datasets. This session will also explore using the Invoke-PowerBIRestMethod cmdlet to call Power BI Service API operations which involve writing PowerShell code to parse together REST URLs and to convert PowerShell objects into JSON to populate the body of an HTTP request. And lastly, you'll learn how to work with the PowerShell cmdlets for On-premises data gateway management to write PowerShell scripts to silently install a data gateway and to manage user access to gateway-bound data sources.