Server Status

[guyinazo]

Can Power BI be used to monitor server status (online, offline, and time offline)?  If so, what would be the best tools or way to do this.

Thanks

[krishn24]

Yes, this is possible - you can use Power Query M-code to achieve this. 
Write M code to create a list of services/Server URLs
Create a function that takes a URL from the list and checks if the server is up or down
Return the results in a table
And finally, schedule the refresh of your data as required.

If this is not possible, create an API for Postman and connect this API to you M Code.

[Anonymous]

Hi @guyinazo,

Is there any rest API that can be used to trace your server status? If that is the case, you can use power bi to invoke the rest API and design a report for trace server status.

If not, you may need to deploy API/service/probe for trace service status then you can view and get data from other tools.

Regards,
Xiaoxin Sheng

[parry2k]

@guyinazo Power BI will not ping the server to check the status, you need to use other tools (I'm not a network/system expert) to determine the status and then feed the data to Power BI. I'm sure there are tons of tools that can do this for you but Power BI is not the right tool to determine the status, it is purely for visualization.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@guyinazo not sure what you are looking for, you can use the streaming dataset if your server can send the data, and then you can visualize it. Real-time streaming in Power BI - Power BI | Microsoft Docs

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[guyinazo]

System statuses is what I am looking for.  If a system is down (usually a service run on a server or the server itself), run a steady ping or whatever it would be to report the server system status.  Maybe a query of the server logs.  And I also know another wrench to this is if the system is cloud-based, on-prem, hosted, etc.  But yeah, if I knew what I was looking for then I wouldn't ask.  But there would be a dashboard of KPIs with our various system statuses and logs.