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

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

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.

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