Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
hamiltong
New Member

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 Combining / Transforming or even just transforming it automatically recognized the 10th row as the header but only displays the fist 9-10 rows of data below.   I've tried remove blank rows - didn't have any affect.

 

Currently, I'm using a VBA script to remove the first 9 rows of each worksheet with the workbook and against all the file in the directory - than I can do a power query combine and transfor no problem with all the data.  

 

Wanted to have power query do it all 🙂 

1 ACCEPTED SOLUTION
hamiltong
New Member

I figured it out.. I need to use the parameter InferSheetDimensions = true to get it to see the rest of the data..  Thanks. 

View solution in original post

2 REPLIES 2
hamiltong
New Member

I figured it out.. I need to use the parameter InferSheetDimensions = true to get it to see the rest of the data..  Thanks. 

ppm1
Solution Sage
Solution Sage

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

Microsoft Employee

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.