# Getting metrics via API

**URL:** <https://community.dynatrace.com/t/getting-metrics-via-api/39480>\
**Category:** Open Q&A\
**Tags:** dynatrace-managed, dynatrace-api\
**Created:** [April 26, 2023, 4:05pm UTC](https://community.dynatrace.com/t/getting-metrics-via-api/39480 "2023-04-26T16:05:51Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paulo1989](https://avatars.discourse-cdn.com/v4/letter/p/3bc359/32.png) [@Paulo1989](https://community.dynatrace.com/u/Paulo1989)\
**Post date:** [April 26, 2023, 4:05pm UTC](https://community.dynatrace.com/t/getting-metrics-via-api/39480/1 "2023-04-26T16:05:51Z")

</div>

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&nbsp; an API Web key when provided by an API KEY NAME

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

Thank you

 ![Captura de ecrã 2023-04-26 164555.png](https://global.discourse-cdn.com/dynatrace/original/2X/8/815c1d6a08f4963f822f5ec858980e77655dcf3c.png)

---

<div class="post-metadata">

**Author:** ![AntonPineiro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antonpineiro/32/49_2.png) [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\
**Post date:** [April 27, 2023, 7:03am UTC](https://community.dynatrace.com/t/getting-metrics-via-api/39480/2 "2023-04-27T07:03:20Z")

</div>

Hi,

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

Just to provide some alternative.

Best regards

---

<div class="post-metadata">

**Author:** ![Paulo1989](https://avatars.discourse-cdn.com/v4/letter/p/3bc359/32.png) [@Paulo1989](https://community.dynatrace.com/u/Paulo1989)\
**Post date:** [April 27, 2023, 7:33am UTC](https://community.dynatrace.com/t/getting-metrics-via-api/39480/3 "2023-04-27T07:33:22Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![AntonPineiro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antonpineiro/32/49_2.png) [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\
**Post date:** [April 27, 2023, 10:52am UTC](https://community.dynatrace.com/t/getting-metrics-via-api/39480/4 "2023-04-27T10:52:23Z")

</div>

Hi,

You have a Dynatrace webinar about [Dynatrace and PowerBi](https://www.youtube.com/watch?v=PNX0jCL8AHc).

Best regards

---

<div class="post-metadata">

**Author:** ![Paulo1989](https://avatars.discourse-cdn.com/v4/letter/p/3bc359/32.png) [@Paulo1989](https://community.dynatrace.com/u/Paulo1989)\
**Post date:** [April 27, 2023, 11:41am UTC](https://community.dynatrace.com/t/getting-metrics-via-api/39480/5 "2023-04-27T11:41:03Z")

</div>

Hi&nbsp;[AntonPineiro](https://community.dynatrace.com/user/58682),

thank you. I’ll go through it

---

<div class="post-metadata">

**Author:** ![Paulo1989](https://avatars.discourse-cdn.com/v4/letter/p/3bc359/32.png) [@Paulo1989](https://community.dynatrace.com/u/Paulo1989)\
**Post date:** [April 29, 2023, 6:53pm UTC](https://community.dynatrace.com/t/getting-metrics-via-api/39480/6 "2023-04-29T18:53:18Z")

</div>

hi&nbsp;[AntonPineiro](https://community.dynatrace.com/user/58682)

thanks for the video it worked perfect

---

<div class="post-metadata">

**Author:** ![AntonPineiro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antonpineiro/32/49_2.png) [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\
**Post date:** [April 29, 2023, 7:45pm UTC](https://community.dynatrace.com/t/getting-metrics-via-api/39480/7 "2023-04-29T19:45:20Z")

</div>

Hi,

You are welcome and happy to read it! 😉

Best regards
