Kobo data return as code not text

[Ladan]

Hi all,
I use this Load KoboToolbox data to Power BI via API connection - YouTube to connect the data on kobo to PBi but the jason file returns the kobo data as codes not as text. Any idea is highly appreciated.

[Kal_Lam]

Welcome to the community, @Ladan! This API should help you connect your data from KoboToolbox to PowerBI.

API Export to Excel Drops Hyperlinks to Photos

@mark_ej, we will be updating our support document very soon. Till then, maybe you could follow the steps outlined below: Step 1: Open your survey project and then make some downloads (by specifying a name to the Save selection as ...) as shown in the image below: [image] Step 2: Now in a new tab, use the following API: https://[kpi]/api/v2/assets/{asset_uid}/export-settings/ Here, kpi refers to kobo.humanitarianresponse.info if you are using the humanitarian server else kf.kobotoolbox.o…