Forum Discussion
Solved
Excel Power Query - All rows not getting imported
I am trying to import data from a folder which has multiple excel (.xlsx) files. Each file is in the same format and has more than 100 rows. However, when trying to merge & import the file, only the ...
In Transform Sample File query please change first step as
// Source = Excel.Workbook(Parameter1, null, true), Source = Excel.Workbook(Parameter1, [UseHeaders = false, DelayTypes = true, InferSheetDimensions = true], null),With InferSheetDimensions = true PQ reads actual sheet dimension, not one which is in metadata.
In Transform Sample File query please change first step as
// Source = Excel.Workbook(Parameter1, null, true),
Source = Excel.Workbook(Parameter1, [UseHeaders = false, DelayTypes = true, InferSheetDimensions = true], null),
With InferSheetDimensions = true PQ reads actual sheet dimension, not one which is in metadata.
Thank you Sergei, this solved my problem as well. (I was looking for like button but couldn't find one so I thank you in this way).