The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi everyone,
I am looking for ways to visualize and monitor the performance of my rack servers using Power BI. I have found some resources that might be helpful, but I would like to hear from others who have experience with this.
Here are some of the things I have found:
Use Performance Analyzer in Power BI Desktop to find out how each of your report elements—such as visuals and DAX formulas—are doing. It's a great way to learn where the bottlenecks are, and how you can improve report performance.
Monitoring SQL System Performance in Power BI. Shawn Frasier of Pinnacle Health Informatics describes a method for monitoring SQL system performance in Power BI.
How to Monitor Power BI Dataset Performance with SQL Server Profiler. This article shows how to monitor Power BI dataset performance and get the DAX queries for a report using SQL Server Profiler.
Monitoring SQL Server with Power BI. This blog post explains how to use Power BI to monitor SQL Server, importing data from query store tables and creating monitoring.
Power BI Report Server Monitoring. This blog post explains how to monitor Power BI Report Server and answer common questions such as who is viewing reports, which reports are the most popular, when are reports being executed, and what is performance like.
PowerEdge-GPU - Servers - Dell. Dell offers accelerated PowerEdge servers and graphics processing units (GPUs) to securely accelerate visualization and insights.
Have any of you used Power BI to monitor rack server performance? What methods have you found to be most effective? Any tips or best practices you can share would be greatly appreciated.
Thank you!
Power BI is a reporting tool, not a real time monitoring tool. The closest you can get in Power BI is to use streaming hybrid datasets.
Real-time streaming in Power BI - Power BI | Microsoft Learn
But you need to acquire your telemetry data yourself, and push it into the dataset.