In Query mode Data is vizible, but in Data mode I see only a blank table.

[Nandor]

Hi,

In Data mode I can't see the data:

If I go into edit Query mode, I can see all the data correctly:

I think that because of this situation I can't link this table to an another table. Please see the message I get in Manage relationships mode:

The Calendar with calcs table is already linked to ananother table, I think that the message in yellow is in fact generated by the second table, the one that I presented in the first two photos, it shows null values. The table is imported from a simple excell table.

Thank you for the help.

[Anonymous]

It is 2020 outside!

come on!

I have the same issue

[Anonymous]

I have this same problem as well. I am using the same format in another dashboard where my sharepoint data pulls in just fine but on the problem dashboard, nothing shows up from file besides a source name column.

Shows up in preview just find though

[Anonymous]

Has this issue been resolved? I am seeing the same thing and I'm not sure how to correct it. 

[Anonymous]

Having the same issue!

[asl10]

Having the same issue!

Please fix it as soon as possible!

[tbennett]

I'm having the same issue, but only with one particular table, which is very odd.

[Tas1]

29/10/2017 I'm having the same issue !!!!!!!!

[dosansil]

08/30/2017 and I got the same issue here. 😞

[ankitpatira]

@Nandor I have experienced this before where in Data view I can't see data but in query editor can. This isn't related to not able to create a relationship issue. The error you getting when creating relation is complaining about null values in FK table. I think it is a bug that you can't see any data under Data view.

[Vicky_Song]

@Nandor, I don't get the same issue as yours. Which version of Power BI Desktop are you working with? How about you downloading and installing the latest version Power BI Desktop and try again? 

[Nandor · Accepted solution]

Hi, I got in contact with the PowerBI team, I sent them over my pbx file, and I got the confirmation that it is a bug, and they are going to fix it with the upcoming releases.