Forum Discussion

sbott's avatar
sbott
Helper I
2 years ago
Solved

Row limit?

Hi, I have an Excel file with 10,135 rows in it, which I imported into Power BI. However, I noriced that some data was missing from the visuals I had created, and then I did some digging I noticed that only 7,767 rows are showing. I have tried refreshing a couple of times but no change, been into the query I only see 7,767 lines and can't see anything that would stop me seeing the other lines.

Need Help
  • j_ocean's avatar
    j_ocean
    2 years ago

    Don't bring in a table, bring in the sheet.

     

    Excel tables sometimes don't extend the full way down, it tries to determine table size based on the left-most column so a blank there sometiems breaks it.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Make sure you use the Excel.Workbook function, and after you bring the table in, go back to the source step and replace the "null, true" with the "[InferSheetDimensions = true]" record parameter, so:

     

    Excel.Workbook(File.Contents("YourFilePath"), [InferSheetDimensions = true])

     

    --Nate

    • sbott's avatar
      sbott
      Helper I
      2 years ago

      Hi, many thanks for your reply. I have nade the change but it is still the same.

       

      = Excel.Workbook(File.Contents("C:\Users\sbott\OneDrive - xxxxxxxxxxx\PBI Data\My Customers All Posted Transactions.xlsx"), [InferSheetDimensions = true])

  • j_ocean's avatar
    j_ocean
    Helper V
    2 years ago

    Don't bring in a table, bring in the sheet.

     

    Excel tables sometimes don't extend the full way down, it tries to determine table size based on the left-most column so a blank there sometiems breaks it.