Kobotoolbox XLS value to Power Bi label through API connection with Json format

[Kal_Lam]

Welcome back to the community, @mt_pin24! Have you tried this approach discussed previously?

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…