cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

POWER BI - Totalcount over 500

Sullivan
Observer

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

3 REPLIES 3

AntonPineiro
DynaMight Guru
DynaMight Guru

Hi,

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

AntonPineiro_0-1711465832924.png

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

❤️ Emacs ❤️ Vim ❤️ Bash ❤️ Perl

Yosi_Neuman
DynaMight Guru
DynaMight Guru

Hi @Sullivan,

Please check @vasile_gafton  answer for your question.

HTH

Yos  

dynatrace certificated professional - dynatrace master partner - Matrix Soft Ware Division - Israel

Sullivan
Observer

Hi everyone,


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

Featured Posts