Table View Font is Invisible

[saikrupa]

Why is the text not visible in the table view? I've checked my settings, but nothing seems to be off. How do I fix this?? I'm just starting to use this software and I've already hit an obstacle. ☹️

[lbendlin · Accepted solution]

the data is there, your first couple rows happen to have all BLANK() values.  Most likely an incorrect Excel Table range definition.

[lbendlin · Accepted solution]

the data is there, your first couple rows happen to have all BLANK() values.  Most likely an incorrect Excel Table range definition.

[saikrupa]

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?

[danextian · Accepted solution]

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.

[mickey64]

    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.