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 (coming soon – Oct 6th)
- Update report parameters (coming soon – Oct 13th)
- Change data source credentials (coming soon – Oct 20th)
- Update refresh schedules (coming soon – Oct 27th)
- Trigger a refresh (coming soon – Nov 3rd)
- Assign workspace permissions to users or groups (coming soon – Nov 10th)
Want to download the PowerShell scripts to perform these actions? Get it from my GitHub repo.