Forum Discussion
Excel spreadsheet not completely loading
Hi all, I have a spreadsheet with 6900 rows however only 6591 of those rows are loading into power bi. Is there any way to resolve this, i have checked data source, checked on transform data an...
A few things to check:
- Are there any blank rows in the Excel spreadsheet?
- Have you applied any filters in Power Query that could be removing rows?
Also, is your data in Excel stored in a table? If not, maybe trying to convert it into a table and then setting up the connection in Power BI from scratch and connecting to the table rather than sheet in which the data is stored.
A few things to check:
- Are there any blank rows in the Excel spreadsheet?
- Have you applied any filters in Power Query that could be removing rows?
Also, is your data in Excel stored in a table? If not, maybe trying to convert it into a table and then setting up the connection in Power BI from scratch and connecting to the table rather than sheet in which the data is stored.