Connecting DT to PowerBI (Retrieving DQL Data)

[Kris_T]

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: https://www.dynatrace.com/support/help/shortlink/ba-api-ingest#dql-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)

[AntonPineiro]

Hi,

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

I would check Log Monitoring API.

Best regards

[Kris_T]

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 

[AntonPineiro]

Hi,

For me, easier way is from here:

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

Best regards

[radek_jasinski]

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

https://www.dynatrace.com/support/help/shortlink/api-authentication#token-scopes