Forum Discussion
Fast Load "export" to Excel
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.
Hi,
die Frage ist, benötigst Du wirklich alle Zeilen, aller Spalten aller Perioden? Vermutlich nicht, denn die Du könntest Du ja auch direkt in der DB ansehen. Deshalb wäre es empfehlenswert, nur die Spalten und Werte, evtl. über Parameter, herauszufiltern, die Du tatsächlich benötigst, so dass (im günstigsten Fall) am Ende nur eine Abfrage (statt 13) als Ergebnis steht, die Du dann auch noch aus der Verbindung heraus (also ohne zwischenladen in eine Tabelle) in PowerPivot weiter bearbeiten kannst.
After translating, the short answer is that I need all the records that's in MS Access to be in MS Excel for audit purposes.
Thus the question asking how to make the load to excel be fast.