XML values instead of Labels in Power Query table

[Kal_Lam]

Would you mind trying the approach as outlined in the post discussed previously (it should solve your issue):

API to GET Kobo submissions using 'label' rather than value

After making your data public: Settings–> Sharing–> [image] USE THIS GENERAL STRUCTURE: Default Language: https://kc.humanitarianresponse.info/“USER_ACCOUNT”/reports/“FORM_ID”/export.csv Or other instance… EXAMPLE of FORM_ID_IN_KOBOTOOLBOX: a5n9jp9qxyiKPfRNYq7KAt If “english” is one of your languages… https://kc.humanitarianresponse.info/ USERNAME /reports/ FORM_ID_IN_KOBOTOOLBOX /export.csv ?lang=english