In Power Query Editor fields displaying as values and tables.

[vignesh-490]

After importing data from the source, while trying to transform data in the power query editor i see the field value shown as "VALUES" and "TABLES " which is actually a numeric value.

How to get rid of it and get the actual values.

[Anonymous]

Just click the button at the top right of the column to see your options. 

--Nate

[Anonymous]

@vignesh-490 
Is there any option of expanding? Can you provide more detail.
Which source are you using, may provide a sample table. See if I can reproduce this.

Paul Zheng _ Community Support Team