Getting metrics via API

[Paulo1989]

Good Afternoon Everyone

I´d like to ask if someone can help me with an extraction report from Dynatrace to Excel or PowerBI

I did all the metrics via apiv2 everything seems ok when I´m uploading the file to excel I put the token and select the the level i pretend to I was receive an info message that says It´s only possible to specify  an API Web key when provided by an API KEY NAME

I pretend to receive an automatic report  about my apps or hosts from dynatrace to Excel or PowerBI

Thank you

[AntonPineiro · Accepted solution]

Hi,

I extract information as plain text normally, a CSV format. You can open CSV in a spreadsheet application as Excel.

Just to provide some alternative.

Best regards

[Paulo1989]

Thanks for the help but I tried this one before and it works perfetly but I need from an API REQUEST to export automatically to Excel or PowerBI if it possible

[AntonPineiro · Accepted solution]

Hi,

You have a Dynatrace webinar about Dynatrace and PowerBi.

Best regards

[Paulo1989]

Hi AntonPineiro,

thank you. I'll go through it 

[Paulo1989]

hi AntonPineiro

thanks for the video it worked perfect

[AntonPineiro]

Hi,

You are welcome and happy to read it! 😉

Best regards