50 Record Limit In Power BI

Implementation - Implémentation
1

Hie!,
I’ve just upgraded to DHIS2.2.37.6 Build 57f2dac. I use Power BI for visualizations using web api. After the upgrade Power BI is pulling only 50 records even if paging is false. Please help!

Kabango

2

Hi @Kabango_Malewezi ,

Could you please share an example of the API endpoint you are using?

By 50 “records” I assume you are pulling tracker data from
api/events
api/enrollments or
api/trackedEntityInstances

Please try adding the &skipPaging=true parameter to the end of the query, instead of &paging=false

See ticket 12163

3 Likes
4

Thanks a lot. It works.
FYI This is the query:
Json.Document(Web.Contents(“https://your.server.here/api/trackedEntityInstances.json?ou=fKDL2Sdwqm7&ouMode=DESCENDANTS&program=alvytZiwX3G&programStartDate=2021-10-01&programEndDate=2022-09-30&fields=:all&paging=false”))
I’ve replaced paging=false with skipPaging=true

Thanks a lot

1 Like