topic Re: Data explorer CSV into Excel in Open Q&A

Data explorer CSV into Excel

elenaperez — Wed, 28 Feb 2024 07:52:58 GMT

Hi,

When trying to export a graph from the data explorer in CSV format, I only get 3 empty columns (metricId, time and value).

I don't want to export the static CSV file because I would like to refresh it from Excel directly. With JSON format, I am having problems getting the graph.
Is there a way to get the CSV file in Excel and be able to update it from there directly?

Thanks in advance!

Re: Data explorer CSV into Excel

AntonPineiro — Tue, 27 Feb 2024 13:34:55 GMT

Hi Elena,

Maybe this can be helpful.

Best regards

Re: Data explorer CSV into Excel

elenaperez — Tue, 27 Feb 2024 13:55:02 GMT

Hi Anton,

No, I added the Api Token like that and it doesn't give me any errors. But the result is not the data for the graph.
Regards.

Re: Data explorer CSV into Excel

PierreGutierrez — Fri, 03 May 2024 21:36:55 GMT

Hi @elenaperez
Yes, it's possible to export data and refresh directly in Excel.

1.- Define your query of Data Explorer.

2.- Use the API to execute the metric selector: https://{environmentid}.live.dynatrace.com/api/v2/metrics .( https://docs.dynatrace.com/docs/shortlink/api-metrics-v2-get-all)

3.- Connect the API in Excel with PowerQuery

With this way you can execute the Metric Selector in Dynatrace API, connect with excel and refresh data

I hope it's helful 💪