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 w...
Updated 8 years ago
Version 13.0
Blog Post
Hello!
Relatively new Power BI developer for my company...and a complete neophyte to PowerShell and Azure. Is this the most current method for integrating PowerShell with an existing Power BI report I've built?
I believe what I'm seeking is pretty simple compared to what others are doing. We basically want a real-time report on our Microsoft 0365 licenses. Previously we were using data from a 3rd party to build the datasets we needed...license, cost, # purchased, # used, employee assigned, their department, etc. I was easily able to take that data in CSV format and create the report I wanted.
As we suspected, we should have access to this data already within our Azure system...question was how to access it, and how to do it in realtime. One of our other developers works almost exclusively in PowerShell and pulled what we needed...and he mentioned he was pretty sure there was a way we could fire off the PowerShell script inside of Power BI so we could get essentially real-time data.
I'm looking for the best place to start tutorial wise given my almost zero level of familiartiy with PowerShell and Azure. I do not have creds within our Azure system, so I'd need the best step by step, "PowerShell integration with Power BI for Dummies" as possible.
Thanks!