I have created a Power BI Template that connects a KoboToolbox Form to Power BI in a simple way. I think that it is simpler waythat the one HERE, I never managed to make it work…Like others I always got a Json Problem)
The file is HERE
It will get you the data with LABEL (Human Readable) in the DEFAULT language of your form.
The data needs to be public for this to work. Thus you need to go to your form and go to SETTINGS–>SHARING
Select: Anyone can view submissions made to this form
I USE THIS METHOD ONLY FOR NON-SENSITIVE DATA AS YOU NEED TO SHARE THE DATA FOR THIS TO WORK!!!
Then when you open it it gives an Explanation of whta it does:
Then you need to insert Kobo_Instance, the Kobo_Account that created the form (not necessarity account your) and the form ID:
Curently you can choose only 2 instances, if anyone is interested in others, please let me know…
The template gives you also a CALENDAR TABLE (From Curbal.com)
Fill up the parameters ( Starting date of your calendar) following the instructions:
Then clik LOAD ( or edit and Load if you need to edit your query)
You will get a Power Bi File that will contain 2 Queries:
You can always go to the Query editor and change them:
As you can see the entered info for the parameters is there:
So it will be the data (KOBO API) ( labels of the Default Language, in my case Portuguese)
ADDITIONALLY…Based on @bareta nice help, I have added a colum with the edit link for ech of the submission. You can create a table that will open them (if you have the permissions)
(Install Json Viewer for Chrome so the Web URL is clickable)
Should you not be logged in Kobotoolbox or not have prermissions (“Edit Submissions”) you will get this message:
I hope this is useful for the community!