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.
When you edited your data in Power Query Editor, you may have performed a filter operation to check the contents of the column data, and that step may have remained unintentionally.
Please check Power Query Editor to see if there are any unnecessary filter steps remaining.