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: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

nakrofft

Data showing in query view but not showing in data view.

Submitted by on ‎03-12-2018 12:28 PM

I’m seeing an issue where a column that is created and populated in the query view is not populated in the data view (although the column IS visible all contents are shown as blank).

 

I have tried re-creating the query, re-naming the column and changing its type, and as far as I can tell this is a bug. Please let me know if there is an existing solution to this issue. 

Status: Needs Info
See more ideas labeled with:
3 Comments (3 New)
Comments
v-jiascu-msft
Employee
Employee
‎03-13-2018 01:57 AM

Hi @nakrofft,

 

I can't reproduce it. Can you share a sample please?

 

Best Regards,

Dale

Vicky_Song
Impactful Individual
Impactful Individual
‎03-13-2018 01:58 AM
Status changed to: Needs Info
 
nakrofft
Regular Visitor
‎03-13-2018 11:25 AM

 Further info:

 

When I create a new column on a query by using a Left Outer Join against another query and then expand the column into the value that I am interested in, the new column appears with the data as expected in the query view. However when I save and apply and go back to the data view the column is blank as shown in the screen cap below.

 

This happens even if I try on and against different queries, seems to be a bug.

 

Image of missing data in data view on right that is shown in query view on left.Image of missing data in data view on right that is shown in query view on left.Thanks

Idea Statuses