•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
#Excel alternatives for data analysis
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#rows.com
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel compatibility
#Excel alternatives
#financial modeling with spreadsheets
#Query
#Data Connection
#Excel
#Power Query
#Snowflake