In Power Query Editor fields displaying as values ...

vignesh-490 · ‎07-06-2021

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.

watkinnc · ‎07-08-2021

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

--Nate

I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

V-pazhen-msft · ‎07-07-2021

@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

In Power Query Editor fields displaying as values and tables.

Helpful resources

Fabric certifications survey

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024