Forum Discussion

Dave_Parkes's avatar
Dave_Parkes
New Member
6 years ago
Solved

Data table is empty

So, I am very new to Power BI and i'm sure there is an easy answer but.... I have 3 tables, Date, Customer info and quote data. All come from Excel, the first 2 show all the data they should in PBI....
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Dave_Parkes,

    It seems like power bi recognizes lots of blank rows as table records so you can only view the blank records. I'd like to suggest you use 'remove blank row' function in the query editor to remove these blank rows.

    How to delete blank rows in Excel using Power Query 
    Regards,

    Xiaoxin Sheng

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Dave_Parkes Can you share some screen shots. I have noticed in Data view that sometimes when you click on a table, nothing shows up but if you click on a column within the table over in the Fields area, everything shows up. Might be that perhaps?

  • Dave_Parkes's avatar
    Dave_Parkes
    New Member
    6 years ago

    I tried as suggested but no successData table is empty but the data is present as it is shown in the filters

    • az38's avatar
      az38
      Community Champion
      6 years ago

      Dave_Parkes 

      hi, I see a lot of blank values here and (blank) value in the filter list. try to check filter out (blank)