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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
JacobM
New Member

Excel source file with grouped content

Hi there,

 

I have an Excel source file with grouped content but Power Query only loads the first 8 rows. Before I can use the file I first have to ungroup and save the file.

 

Is there anyway to load the rows of a grouped Excel file in to Power Query without editing the file first?

 

Grouped.jpg

 

Kind regards,

 

Jacob

3 REPLIES 3
Anonymous
Not applicable

Hi @JacobM ,

 

Any updates?

 

Best Regards,
Eyelyn Qin

Anonymous
Not applicable

Hi @JacobM ,

 

I have tested on my side, and all rows are loaded into Power BI successfully:

Eyelyn9_0-1640067177040.png

 

Can you please share more detail information to help us clarify your scenario?

 


Best Regards,
Eyelyn Qin

lbendlin
Super User
Super User

Please provide a sample file that fully covers your issue. Use one of the file services. Please show the expected outcome.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors