Forum Discussion
Data Not Populating in Table View
Hi there, I'm a little embarrassed to say this, but I had a similar problem... It seems that when someone formats a lot of empty rows in Excel, Power BI may treat those rows as valid records with null values and display them first. That's why it can look like there's no data. It also explains why applying a filter seems to fix the issue. 😅
I spent an hour figuring this out. In the end, I simply filtered out null values from the ID column, which should always contain a value, and the problem disappeared!
I need a beer now. 🍺
Resolver Iif you are curious why. Excel stores in its files what the "last row" and "last column" of the used space is. So if someone formats an entire column to the end of the sheet, the last row can be considered some really large number. A similar thing can happen with columns, you'll notice it if you have extra columns suddenly appear in Power BI that say something like "Column7".
Fixing the excel sheet is usually the best outcome, you just highlight the offending rows/columns and mark "delete rows/columns".
If you can't fix the source, you are correct that you just need to filter blank rows, or use a "remove other columns"