POWER BI - Totalcount over 500

[Sullivan]

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

[AntonPineiro]

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

[Yosi_Neuman]

Hi @Sullivan,

Please check @vasile_gafton  answer for your question.

HTH

Yos  

[Sullivan · Accepted solution]

Hi everyone,

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