Forum Discussion
Solved
Power Query not detecting last column in xlsx files
Hi For the past fortnight, Power Query has failed to detect the last column in the Excel source files (xlsx) which underpin our Power BI dashboards. I have not been able to solve this in Pow...
Try adding the InferSheetDimensions parameter, like
Excel.Workbook(File.Contents("C:\YourFileName.xlsx"), [DelayTypes = true, InferSheetDimensions = true])
This reads the content of the sheet, instead of the (possibly no longer correct) metadata info, to get your data.
--Nate
Try adding the InferSheetDimensions parameter, like
Excel.Workbook(File.Contents("C:\YourFileName.xlsx"), [DelayTypes = true, InferSheetDimensions = true])
This reads the content of the sheet, instead of the (possibly no longer correct) metadata info, to get your data.
--Nate
Nate, superb. This seems to provide the fix I'm looking for. Thank you!