Hi Everyone,
I am currently facing an issue while integrating KoboToolbox data with Power BI. My dataset has grown significantly, reaching approximately 300,000 records, which has caused refresh operations in Power BI to fail due to the large volume of data.
To address this, I would like to apply filters directly to the KoboToolbox API to reduce the size of the dataset before it is imported into Power BI. My goal is to only retrieve relevant records, such as those submitted after a specific date.
I would greatly appreciate your guidance on:
Filtering API Queries:
-
How can I structure my API query to include conditions like retrieving submissions after a certain date or filtering by specific field values?
-
Are there examples or documentation available that explain the use of query parameters for complex filtering?
Thanks,
Warda