Showing results for 
Show  only  | Search instead for 
Did you mean: 

Connecting DT to PowerBI (Retrieving DQL Data)


We are trying to connecting Dynatrace to PowerBI. We want to run DQL Query and have the results in PowerBI, so we can use: DQL queries via API:

But this is a POST Method and not a GET. I have worked with a colleague and we can authenticate with Tokens for the classic platform APIs and use PowerBI/Excel to integrate with the methods mentioned here and in the Dynatrace and PowerBI (YT Video).

I see something similar, but not the same, this is more of RFE (Grail to PowerBI Connector)

How can we connect from PowerBI/Excel to DT, to retrieve DQL Response using the DQL API (POST Method)


DynaMight Leader
DynaMight Leader


Do you know if you token has "Read logs (" permission?

I would check Log Monitoring API.

Best regards

❤️ Emacs ❤️ Vim ❤️ Bash ❤️ Perl

I have read logs permission 
I have client token for OAuth and Token ID for API V2 when using token ID method for getting logs using Get method i am getting Error Token Authentication failed Token Authentication failed

and got stuck,  Since i am new using API's i don't know how to generate bearer token 


For me, easier way is from here:


You can create your token there and play with Dynatrace API Explorer.

Best regards

❤️ Emacs ❤️ Vim ❤️ Bash ❤️ Perl

DynaMight Guru
DynaMight Guru

Remember also to select the appropriate scope of such a token:

Have a nice day!