PowerBi doesn't show the data within the table.

[Naomi_Holz]

Hello!
I'm new in PowerBi and I came across this issue, already ask AI and looked up tutorials, i can't find the problem to solve it.
In the table view the program doesn't show the data, if I go to power query it does show every celd. The column is a PK, so it doesn't have duplicates or empty celds. And the relasionship view shows every celd as null. Does anyone have a clue of what is this problem? Thank you!!
PS. English is not my first language, so I hope the message gets delivered haha

[danextian · Accepted solution]

Hi @Naomi_Holz 

The relationship dialog box displays only the first few rows of a table, which in your screenshot appear to be all blanks. This raises the question—are those rows needed? If not, consider removing them in the query editor.

[Naomi_Holz]

Omg, thank you sooooo much!! I did the relashionship already i can continue, ty

[Ashish_Mathur]

Hi,

You do not see data in the Table view because of blank rows.  If you scroll down, you will see data.  If you want to remove the blank rows, then in PQ, apply filters to remove blanks.

[Naomi_Holz]

Thank you! I didn't think it could be that, it's solved! ty