Dynatrace API / Cluster Management API - GET list of host

[melissap]

I have managed to get the GET list
of hosts API running, but when I bring it into power bi or through excel, I get
the below, so I have to click the record to view the information.

1.How do I get it to a
view to view all the info without having to go into the record?

2.This only allows me
to gather data over the last 30 min, I cannot go further than that? Why is that?

[Joe_Hoffman]

Are you sure your Performance Warehouse is connected? That could explain the 30 minute limit.

As for importing into Power BI or Excel, that is a PowerBI or Excel question.

[melissap]

Thanks, this is for dynatrace managed though

[Joe_Hoffman]

This question was posted to the AppMon forum, that's why I assumed it was for AppMon. I will move it to the Dynatrace Forum.

[dave_mauney · Accepted solution]

See these videos:

Short/silent example, specific to your question:

https://dynatrace-my.sharepoint.com/:v:/p/dave_mau...

Much longer demo that is generic:

https://www.youtube.com/watch?v=CjnsX81qWUg

HTH,

dave