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