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.
YWolf970 - you had a similar problem in this thread (https://techcommunity.microsoft.com/t5/excel/excel-power-query-wont-load-all-rows/m-p/1744695/thread-id/76949) but I didn't understand what the solution was.
SergeiBaklan and NikolinoDE - Any help on this matter would be greatly appreciated.
SergeiBaklan and NikolinoDE - Any help on this matter would be greatly appreciated.
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).
Worked like a charm. Thanks a lot. 🙂 You are a life saver 🙂
Although one small change - I had to make the change in the "Transform File" option and not the "Transform Sample File". But thank you once again 🙂
anidas , you are welcome
