Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

Show and Tell
  • Adescrit's avatar
    Adescrit
    4 years ago

    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.

1 Reply

  • Adescrit's avatar
    Adescrit
    Impactful Individual
    4 years ago

    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.