I get to do some very cool things for customers, and count myself extremely fortunate to have an opportunity to learn something new and do something useful…and get paid for it! I recently developed a PowerShell script to automate the deployment of Power BI workspaces and reports, while doing some other interesting things along the way. At the end of it I knew it was something I wanted to blog about as it may be useful to somebody else out there, but there was just too much content for a single blog and I thought it best to split the individual components and create a series.
In this series we are going to walk through the entire process, using PowerShell and a combination of the Power BI cmdlets and Power BI API. There’s also a few other goodies that I’ve learned on my PowerShell journey and would like to share. Here’s a list of all the items we’re going to cover:
- PowerShell basics
- Connecting to the service
- Creating a workspace
- Deploying reports
- Update report parameters
- Change data source credentials
- Update refresh schedule
- Trigger a refresh
- Assign workspace permissions
Want to download the PowerShell scripts to perform these actions? Get it from my GitHub repo.