Forum Discussion
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....
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
amitchandak
Super User
Super UserDave_Parkes , click on some other table in the data view. Come back and click on one of the fields in this table data view. In the fields list pane at the right side and check
The solution was to delete blank rows