The following steps walk through downloading, opening, and configuring the SQL Sentry Power BI Content Pack through Power BI Desktop.
1. Download: Get a copy of the SQL Sentry Content Pack PBIT file from SolarWinds Support.
2. Open the PBIT file with Power BI Desktop:
3. Update the Server_1 and Schema_Name_1 (database name) parameters to reflect your server\instance name and SQL Sentry database,.
4. Enter the number of SQL Sentry Databases you connect to in the ReportingServers parameter, and then select Load.
5. After selecting OK, a banner appears prompting you to apply the changes. Select Apply Changes:
6. Select File -> Options and Settings -> Options:
7. Select Security, then deselect Require user approval for new native database queries under Native Database Queries.
8. Select File > Save As to open the Save As window. Enter a filename for SQL Sentry PowerBI report, and then select Save to save your report.
9. Select File > Publish > Publish to PowerBI to publish your report in the PowerBI app. Choose the desired destination and then click Select to finalize your publication to PowerBI.
The Disk Space page provides a high-level overview of the available and consumed disk space percentage for your monitored server\instance(s). View the disk space for individual server/instance(s) by Month, and disk drive.
The Memory Usage page provides summary details about the memory usage over time by your monitored server/instance.
The Freespace Forecast page provides a 14 day free space forecast for your monitored server/instance. View forecasts for specific disk drives, and adjust the forecast based on the selected date range.
The Top N page provides a high-level overview of the resource utilization of your monitored server/instance(s). View overall resource utilization across the monitored servers in your environment, or drill down into more specific data by selecting a target and adjusting the date range.
The Top N Details page provides details about the downtime events, conditions, and their corresponding alerts for your monitored server/instances(s) across the specified time period. View a high-level overview of alerts and alerting conditions in your monitored environment, or drill down into more granular details for specific targets.
The Blocks/Deadlocks page provides details about the Total blocks and deadlocks by database, date and month for the selected time period. View more granular details by filtering for a desired Server or address.
The Waits page provides details about the Total wait time by server and name, by category, by class, and by Wait Type. View more granular details by filtering for a desired Domain Name or Resource Group.
The Blocks/Deadlocks page Detail View provides details about the Total blocks by Program and Total deadlocks by application name for a specified server.
The Alerts page provides details about the alerts for your monitored server/instances(s) across the specified time period. View information about the Top Servers with alerts, the total alerts by condition, and the total number of count rows for alerting.