I am dealing with what appears to be a known slow query functionality with Power Query, compared to running the query within Access. I am using PQ to populate a table used in a Pivot-style Excel report. I am trying to automate someone's many manual steps, and the final step in this newly automated report is very slow which is unsettling
Would simply writing out some SQL and pasting it into VBA on the Excel side be better? I have never done that before...
Example is not important - this is any very simple return of small number of rows, which would normally return in a second or less, can take up toa minute to retrieve.
Network is only a small portion of the issue - Access to Access over this same network is much faster than Excel to Access... Even Local Excel to Local Access is slow!