Getting health data from a server or PC

[Anonymous]

We want to set up a TV on the wall in IT that will monitor various details on various servers so that if anything goes wrong we can spot the problem sooner. Some of these details could include:

- Remaining hard drive space

- RAM usage

- Ping times

- Connecting to services on that machine

I figured that Power BI would be a great way of doing the interface (I will make multiple dashboards that will cycle through in chrome using the revolver extension). Are there any connectors that will achieve some/all of this? Alternatively, is there a connector where you can run a powershell script and return data to Power BI?

It would be great if we could do some of this as real-time streaming, if not we would have to do pretty regular updates.

[v-yuezhe-msft · Accepted solution]

@Anonymous,

You can use R script to execute PowerShell script and import required data in Power BI Desktop, for more details, please review this blog:http://tinylizard.com/using-powershell-data-source-power-bi.

After you publish PBIX file to Power BI Service, you can set schedule refresh for the dataset with gateway, and you are limited to refresh 8 times a day. However, if you have Power BI premium license, you can refresh 48 times a day.

Regards,
Lydia

[Anonymous]

Cool, thanks for that. Looking at maybe using this for things that don't have to be real-time and spiceworks monitor for those things that need to be real-time, then just revolving the chrome tabs.