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:

  1. PowerShell basics
  2. Connecting to the service
  3. Creating a workspace
  4. Deploying reports (coming soon – Oct 6th)
  5. Update report parameters (coming soon – Oct 13th)
  6. Change data source credentials (coming soon – Oct 20th)
  7. Update refresh schedules (coming soon – Oct 27th)
  8. Trigger a refresh (coming soon – Nov 3rd)
  9. 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.

2 thoughts on “Automating Power BI deployments: A series

Leave a Reply

%d bloggers like this: