I am currently facing issues with the PowerBI connection and an existing Kobo form that contains more than 90,000 records.
Even when attempting to retrieve the data via the browser link: https://eu.kobotoolbox.org/api/v2/assets/form_id/export-settings/export_id/data.xlsx
I receive a 504 error after 60 seconds.
Does anyone have ideas on how to resolve this? Is it possible to add parameters to the link to retrieve only the last X number of records for the XLSX data?
Welcome back to the community, @slovak82! Pinging @osmanburcu (our Power BI expert) for your support!
Dear @slovak82 and @Kal_Lam, as far as i know it is not possible to retrieve only x number of submissions for XLSX file but it is possible for the JSON format, only down side for JSON is your data will come in XML format not label.
hello @osmanburcu
i am currently facing a similar issue, i have built a powerbi report for a Kobo form with around 50 000 records and around 130 columns. I am using a xlsx link, and i also receive a 504 error after 60 seconds.
What workaround do you recommend ? What are the limits of the xlsx link? How can i get that link in JSON format?
Hi @lisa_vdh, There is two options that i can suggest, first one you can try to increase the time out duration in the power bi to see if it is working for you. Under From Web, Advance option, there is Command time out filled, try to enter some big numbers and see if time out still an issue.
If it doesn’t work, you can use the the link below, to import your data in smaller JSON batches to avoid the time out problem. You can create smaller or bigger group by changing the limit.
https://eu.kobotoolbox.org/api/v2/assets/{formuuid}/data.json/?start=0&limit=26000
https://eu.kobotoolbox.org/api/v2/assets/{formuuid}/data.json/?start=26001&limit=50000
