Forum Discussion
Dave_Parkes
6 years agoNew Member
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....
- Anonymous6 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
Dave_Parkes
6 years agoNew Member
I tried as suggested but no successData table is empty but the data is present as it is shown in the filters
az38
6 years agoCommunity Champion
hi, I see a lot of blank values here and (blank) value in the filter list. try to check filter out (blank)