Forum Discussion
Table View Font is Invisible
the data is there, your first couple rows happen to have all BLANK() values. Most likely an incorrect Excel Table range definition.
If Excel is the source, Power BI usually pulls the whole used range - even cells that used to have data but are now empty. In Data view, try sorting the row. The data is like there. To get rid of the blank rows, either filter them out in Power Query using a column that shouldn’t have blanks, or clean up the unused range in Excel itself by deleting the rows and not just the contents.
I didn't edit the data in Power Query, it was ready to load without that step. I just checked the editor, and it looks normal. Am I missing anything?
If Excel is the source, Power BI usually pulls the whole used range - even cells that used to have data but are now empty. In Data view, try sorting the row. The data is like there. To get rid of the blank rows, either filter them out in Power Query using a column that shouldn’t have blanks, or clean up the unused range in Excel itself by deleting the rows and not just the contents.