Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@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

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
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@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

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.
Anonymous
Not applicable

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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.