Kobo Toolbox Power Query Functions

Use in Power BI or Excel's Power Query Editor

Power Query Functions to request data from Kobo Toolbox using the API v2 (kpi).

FnGetSurveyData

Returns data from a form submitted to KoBoToolbox using the API Token and Asset UID.

FnGetSurveyChoices

Returns a table with the choices from a KoBoToolbox form using the API Token and Asset UID.

KoboToolbox functions.pbix

Power BI file sample with Kobo Toolbox functions.

To find your API Token go to https://kf.kobotoolbox.org/token/?format=json

To find your form Asset UID go to https://kf.kobotoolbox.org/api/v2/assets/

More information on Kobo Toolbox API: https://support.kobotoolbox.org/api.html