Refresh data in Power BI through DirectQuery from Primero

Primero IMS
1

Hi support team,

I am refreshing the data in the Primero Power BI dashboard as usual, normally it is working okay, however this time, it pull only 1000 row data to refresh (i.e. showing cases from 2021-2024), I could not find cases before 2021. As a result, only 999 cases show in the refresh dashboard as apposed to all the total cases from Primero. Do you know what might be the reason? is there any change with Primero that effect this DirectQuery? or it is about Power BI? Please suggest solution.

Thank you very much.
Phanneth Khauv

2

Hi Phanneth, we are still working on a solution for this as we are trying to learn a bit more about PowerBI. I will update you within the next week about how we can solve this.

3

Hi @pkhauv , API requests are limited to a maximum of 1,000 records since v.2.10.3 16 May 2024. Please find the guide on how to get paginated data from API in Power BI.