Forum Discussion
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?
Kind regards,
Jacob
3 Replies
Please provide a sample file that fully covers your issue. Use one of the file services. Please show the expected outcome.
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
