cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MicWit Regular Visitor
Regular Visitor

Getting health data from a server or PC

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Getting health data from a server or PC

@MicWit,

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Moderator v-yuezhe-msft
Moderator

Re: Getting health data from a server or PC

@MicWit,

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

MicWit Regular Visitor
Regular Visitor

Re: Getting health data from a server or PC

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.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 288 members 2,773 guests
Please welcome our newest community members: