Data explorer CSV into Excel

[elenaperez]

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!

[AntonPineiro]

Hi Elena,

Maybe this can be helpful.

Best regards

[elenaperez]

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.

[PierreGutierrez · Accepted solution]

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 💪