I usually do this:
ALSO EXPLAINED IN A VIDEO TUTORIAL: HERE
The turorial is for POWERBI but POWERQUERY is the same.
Go to settings–>Sharing and click in “Anyone can view submissions made to this form” ( cautions with sensitive data)
Then, if you have no language specified (Default language), create your query to the following WEB:
https://kc.humanitarianresponse.info/“USERNAME”/reports/“ID_STRING”/export.csv
if you have defined othe languages (EX: “::english”) in your form:
https://kc.humanitarianresponse.info/“USERNAME”/reports/“ID_STRING”/export.csv?lang=english
Where “USERNAME” is: your account name
and “ID_String” is the +20 caract name of your form…when you click on it would be something like :“aPnv9qNPKT5HG4e8i9rR9n”
EXAMPLE: https://kobo.humanitarianresponse.info/#/forms/aPnv9qNPKT5HG4e8i9rR9n/landing
This metod gives you the answers and data in “Readable” language , instead of the names.
Does it help?
