Forum Discussion
Power Query Slow When Pulling Data From Exchange
I'm attempting to pull in Categories and Attributes.LastModifiedTime in via Power Query, but it's going exceedingly slow, taking about an hour and a half to grab the approximately 50,000 e-mails in o...
Do you use Power BI lastest version: September 2019 Update (2.73.5586.561)?
Or do you use power query for excel : version 2.59.5135.201 ?
You could use Table.Buffer to speed up query.
There are many methods to speed up queries.
Performance tip for List.Generate (1): Buffer your tables in Power BI and Power Query
Table.Buffer for cashing intermediate query results or how workaround Unnecessary Queries Issue
Best Regards
Maggie
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.