Excel spreadsheet not completely loading

[Anonymous]

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 and refreshed multiple times.

[Adescrit · Accepted solution]

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.