Power query data

Hi All ,

I am trying to download data in excel with the help of power query.
effort was successful , but the data was not downloaded as per label which i had set in xls format rather name is downloaded .

please help , how can i get the data downloaded in label in power query.


Hi @caneeraj,

Could you shown us the sample (maybe with an example) of what you are seeking and what you were able to download so that we could best respond to your query.

Have a great day!

Hi @caneeraj
Normally the data is downloaded with the values as opposed to the labels. So if you have your values set as 1 for Male then 1 is what will appear.