cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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
Highlighted
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
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 161 members 1,601 guests
Please welcome our newest community members: