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.

How to connect

  1. Select Get Data at the bottom of the left navigation pane.

  2. In the Services box, select Get.

     

  3. Select SQL Sentry  > Get.

  4. Provide the Database ID of the database you’d like to monitor in Power BI. See more details on finding this below.

  5. 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.

  6. 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 *:

  7. 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.

What Now?

What's included

The following data is available from SQL Sentry  in Power BI :

Table name Description
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.

Finding Parameters

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:

![](https://dpspowerbi.blob.core.windows.net/powerbi-prod-media/powerbi.microsoft.com/en-us/documentation/articles/powerbi-content-pack-sql-sentry/20170906112627/database2.png)

The Database ID is also shown on the Database Details screen:

![](https://dpspowerbi.blob.core.windows.net/powerbi-prod-media/powerbi.microsoft.com/en-us/documentation/articles/powerbi-content-pack-sql-sentry/20170906112627/database.png)

Troubleshooting

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.

See also

Get started with Power BI

Get Data for Power BI