Excel source file with grouped content

[JacobM]

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?

Kind regards,

Jacob

[v-eqin-msft]

Hi @JacobM ,

Any updates?

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @JacobM ,

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

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

Best Regards,
Eyelyn Qin

[lbendlin]

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