Powercli scripts to Microsoft Power BI

[BMH1972]

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

[scott28tt]

Moderator: Moved to PowerCLI

[LucD]

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:

• Building a Dashboard with Grafana, InfluxDB, and PowerCLI
• Fluxor PowerShell Module
• How to create a Grafana metrics dashboard via Influx and PowerShell

Basically you would need to replace the receiving DB and use PowerBI's own dashboard functionality.

Which GetClusterStats script are you referring to?

[LocalManMark]

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-stre...