Forum Discussion

sbott's avatar
sbott
Icon for Helper I rankHelper 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 th...
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.

j_ocean's avatar
j_ocean
Icon for Helper V rankHelper 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.

sbott's avatar
sbott
Icon for Helper I rankHelper I
2 years ago

That worked, many thanks.