Forum Discussion

Naomi_Holz's avatar
Naomi_Holz
New Member
1 year ago
Solved

PowerBi doesn't show the data within the table.

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

 

 

  • 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.

     

4 Replies

  • 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's avatar
      Naomi_Holz
      New Member

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

  • 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's avatar
      Naomi_Holz
      New Member

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