Solved: Excel spreadsheet not completely loading

Anonymous · ‎03-02-2022

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 · ‎03-02-2022

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.

Did I answer your question? Mark my post as a solution!
My LinkedIn

View solution in original post

Adescrit · ‎03-02-2022

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.

Did I answer your question? Mark my post as a solution!
My LinkedIn