cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tadcock
New Member

values show in column in query editor but values don't show in data view

I used the Power Query Editor to prepare the data I imported and all the data I needed showed in the Editor.  I then selected close and apply and went to the data view.  I have a column for the supervisor's name which was populated with values when I was viewing in the editor, but now in data view, the field is blank in every row. What would cause this? My first thought was table relationships but they look correct.

3 REPLIES 3
v-yulgu-msft
Microsoft
Microsoft

Hi @tadcock,

 

"but now in data view, the field is blank in every row"

Did values become blank in table view or in report visual? Could you please show us a screenshot?

Did this behavior occur to specific field or all fields?

 

Regards,

Yuliana Gu

 

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Is there any solution for this...?  I have the same issue, and what was proposed as a solution (check relationships and joins etc) wouldn't apply, as I'm not doing any of that with this table.

The column is just suddenly empty. It is both in the data/table view and in the visuals. It concerns only 2 columns. 

davehus
Resolver II
Resolver II

Hi - Have you checked that the data type are the same for the columns you are joining on. Actually has a similar situation today and that was the reason for the blank values.

D

Helpful resources

Announcements
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!