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.
anidas Had a look at your query and underlying files. Downloaded two of them and connect to them in a dedicated Folder, and returned 200 rows back to Excel. See screenshot. So, there doesn't seem to be a problem with the query.
Riny_van_Eekelen - Firstly, thank you for looking into this.
Secondly, I have all these workbooks saved on the cloud in my onedrive. If I save them in my HDD and not on the cloud, will that actually resolve the issue?
Secondly, I have all these workbooks saved on the cloud in my onedrive. If I save them in my HDD and not on the cloud, will that actually resolve the issue?