Forum Discussion
Solved
Power Query - Not able to ingest data past 10 rows
Power Query, Data from Folder, Multiple excel 2k files with same data structure and multiple worksheets, every worksheet has 9 blank rows to start and the 10th row is the header data. When Combinin...
I figured it out.. I need to use the parameter InferSheetDimensions = true to get it to see the rest of the data.. Thanks.
You don't need the VBA. PQ can do it all. Please share the M code from the Advanced Editor transform sample file query (or just look for a step that is keeping only the 10 rows).
Pat