Error message seen when using excel power query

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,

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

@Namrud, we will let you know when we fix this issue.