Analyzing your performance data collected by SQL Sentry is easy with Power BI. Power BI retrieves your data, then builds a default dashboard and related reports based on that data.
Connect to the SQL Sentry content pack for Power BI.
Note: Access to a SQL Sentry account you use for connecting to http://cloud.sqlsentry.com and a Database ID you will monitor is required to connect. Instructions for where to find the Database ID are below.
Select Get Data at the bottom of the left navigation pane.
In the Services box, select Get.
Select SQL Sentry > Get.
Provide the Database ID of the database you’d like to monitor in Power BI. See more details on finding this below.
For Authentication Method, select oAuth2 > Sign In.
When prompted, enter your cloud.sqlsentry.com credentials and follow the SQL Sentry authentication process.
The first time you connect, Power BI prompts you to allow read-only access to your account. Select Grant to begin the import process. The import process can take a few minutes depending on the volume of data in your account.
After Power BI imports the data you will see a new dashboard, report, and dataset in the left navigation pane. New items are marked with a yellow asterisk *:
Select the SQL Sentry dashboard.
This is the default dashboard that Power BI creates to display your data. You can modify this dashboard to display your data in any way you want.
Try asking a question in the Q&A box at the top of the dashboard
Change the tiles in the dashboard.
Select a tile to open the underlying report.
While your dataset will be schedule to refreshed daily, you can change the refresh schedule or try refreshing it on demand using Refresh Now
The following data is available from SQL Sentry in Power BI :
|Connection||This table provides information about your SQL Sentry defined connections.|
|Date ||This table contains dates from today back to the earliest date from which performance data was collected and retained.|
|Downtime ||This table contains information related to your downtime and uptime for each server that is monitored in your environment.|
|Memory Usage ||This table contains data about how much memory is available or free in each of your servers. |
|Server ||This table contains records for each server in your environment.|
|Server Health ||This table contains data for all the events generated by custom conditions in your environment, including severity and count.|
The Database ID can be found by logging into https://cloud.sqlsentry.com in a new web browser window. The Database ID is listed on the main overview page:
The Database ID is also shown on the Database Details screen:
If data from some of your apps is not showing up in Power BI, check to make sure that you are using the correct Database ID and that you have the authority to view the data.
If you are not the owner if the SQL Sentry database that is being synchronized to https://cloud.sqlsentry.com, please contact your administrator to make sure you have rights to view the collected data.