Has anyone successfully been able to take ps scripts such as GetClusterStats and direct that output into MS PowerBI to generate a dashboard for capacity planning and trending?
Any other ideas for something similar?
Thank you
Brian
Moderator: Moved to PowerCLI
There are several samples of feeding statistics into a DB and displaying it in a dashboard.
I just don't know of an example using PowerBI, except for this short blogpost (see Streaming Datasets – PowerShell | PowerCLI | Power BI).
Some examples based on InfluxDB and Grafana:
Basically you would need to replace the receiving DB and use PowerBI's own dashboard functionality.
Which GetClusterStats script are you referring to?
I've recently been playing around with exporting data from Vsphere into PowerBI. For static reporting I an just exporting to CSV for each entity (VM, Cluster, Hosts, etc) and then creating a relational dataset.
I have managed to create some realtime dashboards too using this blog https://www.google.com/amp/s/blog.jonathonharper.com/2018/04/16/powerbi-report-for-vmware-using-streamed-dataset/amp/