Data explorer CSV into Excel

Platform Open Q&A
, , ,
1

Hi,

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

elenaperez_0-1709039787637.png

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!

2

Hi Elena,

Maybe this can be helpful.

Best regards

3

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.

4

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

1.- Define your query of Data Explorer.

PierreGutierrez_0-1714771470511.png
PierreGutierrez_0-1714771470511.png1457×168 9.23 KB

2.- Use the API to execute the metric selector: https://{environmentid}.live.dynatrace.com/api/v2/metrics .( Metrics API - GET metrics — Dynatrace Docs)

PierreGutierrez_1-1714771958656.png
PierreGutierrez_1-1714771958656.png969×500 60.5 KB

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 :flexed_biceps: