Forum Discussion
Excel import creating phantom rows
I'm completely new to Power BI and really trying to find a comprehensive source for learning how Power BI works right now. My first assignment is to load data from Excel into Power BI to simply disp...
Grouped Cells (or hidden cells) may be a cause, but there any several other possibilites. You may be able to Replace Values or Fill your data in Query Editor to compensate for what imported. But you'll have to see what's 'missing' in the extra imported columns. If you can share the Excel, or PBIX, or good screen shots we might be able to help further.