Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
vignesh-490
Frequent Visitor

In Power Query Editor fields displaying as values and tables.

‎07-06-2021 01:43 AM

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.

Message 1 of 3
831 Views
0
2 REPLIES 2
watkinnc
Super User
Super User

‎07-08-2021 09:51 AM

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!!
Message 3 of 3
751 Views
0
V-pazhen-msft
Community Support
Community Support

‎07-07-2021 07:52 PM

@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

Message 2 of 3
768 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All