Problem in connecting kobo to excel or power bi

[jihadsh]

I have problem in connecting kobo to excel or power bi
the connection run correctly but the labels of questions and choices designed in kobo do not appear , instead of it XML values appear

[osmanburcu]

Hi @jihadsh

are you using API v1, or API v2?

[jihadsh]

Hi
I am using v1

[osmanburcu]

This is the how v1 works, as far as i know, You can use the API v2. It will work as you need.

https://eu.kobotoolbox.org/api/v2/assets/

[jihadsh]

thank you @osmanburcu
I used instructions in this post

API Export to Excel Drops Hyperlinks to Photos

Hi - I followed excel power query instructions to push data to excel. It works well, except hyperlinks to photos are not included - only a number reference in the form 12385875.jpg. How can I push the entire hyperlink to excel through the API? If I export as an XLS file within Kobo (rather than pushing through the API), then the full working hyperlink appears. Many thanks.

and everything worked correctly

[jihadsh]

Hi
No everything pushed to excel even photo url but power query define the column as text variable
You just need to enter the cell in a edit mode then leave it without change to identify cell content as link

If you did not see photo url column ,may be you didn’t select it in kobo in data page at advanced settings

[jihadsh]

I think you must make sure that you choose the URL column before you save settings in data > Downloads > Advanced options