Power BI is an extremely powerful data and visualization tool. It has opened a new world for me. But, the first thing I always think about when looking at Microsoft products is that there must be a way to control this with PowerShell. I did not find any useful information about any PowerShell module on the product pages. After some googling, I found a module on the PowerShell gallery potentially created by a Microsoft employee. What's surprising is that the module has been out for about 7 months and does not have many downloads. Why hasn’t this been more popular? Hopefully I can help change this with a series of blog posts looking at the possibilities of Power BI and PowerShell.
Let's take a look at what is needed to get started and set up the connection/integration.
What is needed:
Azure active directory tenant and organizational user.
You can read more about the PowerShell module for Power BI here, Now, you are ready to start sending data into Power BI from PowerShell. In the next blog article, part 2, I will take a look at how we use the Power BI module and how to visualize the data in Power BI reports. In the part 3 blog article I will take you through the steps to automate in Azure.
This article was first published on my blog alexholmeset.blog.