Forum Discussion
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...
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.
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
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])