topic Re: POWER BI - Totalcount over 500 in Dynatrace API

POWER BI - Totalcount over 500

Sullivan — Tue, 26 Mar 2024 14:53:17 GMT

Hi everyone,

I would like to know if anyone has used Power BI to export problem data from API V2.
API V2-> Problems -> List of problems observed in the specified period.

I am experiencing a problem I have +500 problems, how do I get more than 500 rows in PowerBi?

Request :

https://mytenant/api/v2/problems?pageSize=500&from=now-30d&problemSelector=status%28closed%29

Re: POWER BI - Totalcount over 500

AntonPineiro — Tue, 26 Mar 2024 15:13:30 GMT

Hi,

I do not use Power Bi but you need to iterate against "nextPageKey" in body answer:

We need to make a loop until that is null, it means, you need to call problems API more than one time, in chunks of maximum 500.

Best regards

Re: POWER BI - Totalcount over 500

Yosi_Neuman — Sat, 30 Mar 2024 08:53:10 GMT

Hi @Sullivan,

Please check @vasile_gafton answer for your question.

HTH

Yos

Re: POWER BI - Totalcount over 500

Sullivan — Wed, 10 Apr 2024 13:34:57 GMT

Hi everyone,

Thank you very much for your answers, I've managed to do it in PowerBi.