Row limit?

[sbott]

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.

[j_ocean · Accepted solution]

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]

That worked, many thanks.

[watkinnc]

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]

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])