Edit

Share via

Dynatrace Grail (Beta)

Summary

Item Description
Release State Beta
Products Power BI (Semantic Models)
Power BI (Dataflows)
Fabric (Dataflow Gen2)
Authentication Types Supported Windows (Power BI Desktop)
Organizational account
Function Reference Documentation Source

Note

The following connector article is provided by Dynatrace, the owner of this connector and a member of the Microsoft Power Query Connector Certification Program. If you have questions regarding the content of this article or have changes you would like to see made to this article, visit the Dynatrace website and use the support channels there.

Prerequisites

It's assumed that a Dynatrace environment is already configured for connection from Power BI Desktop.

On Microsoft Azure, that can be done through the Marketplace and searching for Azure Native Dynatrace Service.

Follow the instructions to set up a Dynatrace SaaS environment. Make sure the environment is set to the new version and not the previous classic version, as the latest version contains the Dynatrace Grail data lakehouse and is set up for the authentication requirements for the connector.

Capabilities Supported

  • Import mode only
  • Option to enter a DQL query when connecting—limited to a maximum of 1 million rows

Connection to Dynatrace Grail from Power BI Desktop

To connect to a Dynatrace SaaS instance from Power Query Desktop, take the following steps:

  1. Select Dynatrace Grail DQL in the get data experience. For more information, go to Where to get data.

    Screenshot of the Get Data dialog to connect to Dynatrace Grail.

  2. Enter your Dynatrace environment. This environment needs to be the latest Dynatrace version with Grail enabled. The DQL query is optional at this point, but should be used for more complex queries outside of the default built in queries.

    Screenshot of the environment entry dialog box for the Dynatrace tenant to connect to.

  3. Sign into your environment to authenticate your permissions.

    Screenshot of the Power Query authentication dialog when you sign in.

  4. A browser window pops up that requires you to enter your credentials.

    Screenshot of the Windows authenticated user account to select.

  5. Once you successfully authenticate, the message shows that you're currently signed in. Select Connect.

    Screenshot of a successfully signed in dialog box.

  6. The Navigator screen shows the record types available to select from Dynatrace Grail.

    Sample screenshot of record types available in Dynatrace Grail.

  7. Selecting one of them logs in this example, and runs a fetch logs DQL query with a default 1000 row limit. You require permissions on the Dynatrace environment in order to run this query successfully.

    Sample screenshot of a resultant DQL log query from Dynatrace Grail.

  8. The advanced editor shows the M code the connector is using.

    Screenshot of the connector in Power Query M code.

  9. An optional step when connecting is to type in a DQL query directly. The following example fetches logs (default last 2 hours) with a limit of 1,000 rows.

    Screenshot of a sample DQL query that can be used in the connector.

  10. The resulting import into Power BI looks similar to this example.

    Screenshot of a sample set of Log rows imported into Power BI.

Troubleshooting

  • The latest version ("New" not "Classic") of Dynatrace SaaS is required.

  • The correct permissions outlined in Dynatrace documentation are required to be able to:

    • Connect to the environment
    • Run DQL queries against the Dynatrace platform