XML values instead of Labels in Power Query table

Dear Colleagues,

I am facing an issue similar to the topic “XML Values in Table are displayed” posted a month ago.

I try to collect my data with power query, but some results appear in xml values instead of labels. Take into consideration that I have reset the table data as suggested by @kal_lam but the issue persists. I also tried to delete some entries (results) and the power query keeps showing the initial table (current + deleted results). When downloading my data in excel the dataset seems fine (only current results with labels instead of xml values). The issue appears when using power query.

Please advise.

Best,

Hi @kiryakos,

Could you kindly list down the exact steps you followed and also share with us the screenshot of the same so that we could also replicate it at our ends.

Dear @Kal_Lam,

I created a project with and then I changed the XML values from “automatic” to numbers (1, 2…), which if I am not mistaken were later changed automatically back to this
image

I redeployed the project to it’s final version, submitted a couple of forms and then used the instructions to get my data using power query. This worked well apart from some results which appeared with XML values
image

I followed your instructions reseting my data but this didn’t solve the issue.

I then deleted four of the five entries from the online table to see if this would affect the results appearing on the query but nothing happened (EDIT: today the results were refreshed in the query succesfully, but XML values still remain there)

As a desperate solution I made a clone of the project and created a fresh excel to get the new data with power query. Unfortuntately, the results also inlude XML values instead of labels
image

I also reset the results of the clone but the issue persists.

Best

Would you mind trying the approach as outlined in the post discussed previously (it should solve your issue):

thank you for the reply,

I followed the instructions and downloaded a csv file, which includes the data in labels as expected. I also used the link to feed it to power query, but I am afraid it only receives one tab and not the extra ones for the repeat questions. Unless I am doing something wrong.

Best,

If you wish to work with the repeat groups, here is a post discussed previously (it should help you solve your issue):

Dear @Kal_Lam

I am afraid that even though this thread and video helped a lot in my general understanding of the API and how to pull data, they don’t solve the issue I am facing.

In particular, even though I am now pulling data using json as instructed in the video, the data still appears with XML values instead of labels.

Best,

It seems like you have multiple deployments and you changed some value codes with the later deployment. Did this happen?

Yes, indeed.

If this is the case, it should be a bug as outlined in the post discussed previously:

Also please be informed that i have created a GitHub issue for the same.

Dear KaI_Lam, I have been trying to resolve this issue of showing labels instead of XML through connected Excel/PowerBI. While my KPI is kobo.unhcr.org, this solution doesn’t work for me (I get error 404 in all variations I tried). I would really be grateful if you could give me a hint about what is going wrong, although I was referred before to the dedicated UNHCR server admins to solve technical issues but I’m still searching for our own portal and haven’t been able to reach any of them yet.
Thank you very much!