•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel Query vs data connection, Query much slower
I've been working on overhauling some reporting and really struggling to get a good/fast/easy to maintain setup. Currently I have a workbook with a fixed "Connection" (under queries & connections) to snowflake databases that can import about 66K rows of data in roughly 10 seconds.
Cannot use the connection in power query or data model as I need so I tried recreating it as a query, copy/pasted the connection string and command text from the connection into a Query so that I can more freely use it, but it goes from 10 seconds to refresh to 3-4 minutes to load the exact same 66K rows of data.
Is there something I'm missing?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com