Data from power BI query does not show up in data view

[Anonymous]

Hi, 

I am a power BI newby. I have created 4 tables based on excel data in power BI query editor.

Everything seems fine. When I am in the data view sheet I see the data of 3 out of 4 table -> see for instance last picture.

However 1 table called "customer" I only see empty/blank cells in the data view (see first picture). In the query editor (second picture) I do see all the data. Does somebody know what I do wrong. Just want to have the data visible also in data view. 

BTW when I create a visual or graph I can use the data of the empty table even if it is not visible.

Hope someone can help!

Thanks in advance 

[harshnathani]

Hi @Anonymous ,

I suggest you close the file and reopen it.

Else try refreshing data

Regards,

Harsh Nathani

[Anonymous]

Thanks for your quick reply. Unfortunatly this I have tried in several ways but doesn't solve the problem 

[parry2k · Accepted solution]

@Anonymous I have a feeling there is data but empty cells are shown on the top, if you click on the arrow next to the customer name, do you see a list of customers?

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Wauw....... You are fully right. Spend 30  minutes on it before posting it here. Incredible for a guy working over 10 years daily with excel that I missed that. Many thanks anyway!