Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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:
Select Dynatrace Grail DQL in the get data experience. For more information, go to Where to get data.
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.
Sign into your environment to authenticate your permissions.
A browser window pops up that requires you to enter your credentials.
Once you successfully authenticate, the message shows that you're currently signed in. Select Connect.
The Navigator screen shows the record types available to select from Dynatrace Grail.
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.
The advanced editor shows the M code the connector is using.
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.
The resulting import into Power BI looks similar to this example.
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