Forum Discussion

JustDavid's avatar
JustDavid
Helper IV
6 months ago
Solved

Fast Load "export" to Excel

Hello PQ Gurus,   I have a MS Access file from IT that has 12 million rows (for simplicity).   Due to the limit of rows in Excel, I'm trying to export these 12 million rows into 12 sheets (1 mill...
Need Help
Show and Tell
  • v-priyankata's avatar
    v-priyankata
    5 months ago

    Hi JustDavid 

    Thank you for reaching out to the Microsoft Fabric Forum Community.

    ralf_anton Stachu MarkLaf pcoley Thanks for the inputs. Suggestions from users are valuable.

    The slowness is mainly because Excel has to write millions of rows into worksheet cells, which naturally takes time. Power Query preview feels fast since it only shows a small sample of the data, but when loading, Excel must write the entire dataset. To improve it slightly, you could ensure the filtering happens in MS Access (using saved queries) so only the needed rows are retrieved, set Excel calculation to Manual, and disable background refresh during the load. Even with these steps, exporting 12M rows to worksheets will still take some time, as the limitation is mostly on Excel’s side rather than Power Query.

     

    If there are any deviations from your expectation please let us know we are happy to address.

    Thanks.

v-priyankata's avatar
v-priyankata
Community Support
5 months ago

Hi JustDavid 

Thank you for reaching out to the Microsoft Fabric Forum Community.

 

I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.

 

v-priyankata's avatar
v-priyankata
Community Support
5 months ago

Hi JustDavid 

Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.