Hello @Kal_Lam ,
I have the same issue, I cannot pull data from Kobo api to excel-power-query with labels, using the previous api method, see below.
I would appreciate your kind help, please.
Welcome back to the community, @Namrud! Have you made your data public or tried the steps as outlined in the support article:
If you follow the steps as outlined in the support article, you should be able to solve your issue.
Dear @Kal_Lam ,
I have followed the steps outlined in the support articale, Also, I made my data public, but still I cannot see the labels.
this is the api link I got applying steps outlined in the support articale.
this is how I can see the pulled data, as you can see these should be location names/admin ex. governorate, districts, and subdistricts names.
thanks for your follow up,
best regards,
Namrud
Dear @Kal_Lam,
thanks for your support, any updates from your end, I have followed up all the steps as shown in the updated artical Pulling Data Into Excel Power Query. [image]
but still, the data pulled is on value format not lables.
this is how the data appear when pulling data following steps in artical abovementioned.
this is how I want to see the data
best regards,
thanks in advance for your support
![[image]](https://forum-kobotoolbox-org.s3.dualstack.us-east-1.amazonaws.com/original/2X/f/f87a7820868590a5cd18ee6b93ab21a657e19066.png){kind=link}