Power Query Connecting to Datasource
It takes 2 minutes to connect to two Power Query tables in a 724 KB Excel file.
The source data comes from two Excel files: the first Excel file is 10.3 MB and has five tables used in subsequent queries; the second is 388 KB of raw data.
The two “final” tables are fed by 9 “connection only” or feeder queries with five different merges.
One of the final tables is 1,860 rows and the other is 730 rows.
There is nothing especially fancy or complicated in any of the Queries except for “pivots.”
None of the “connection only” queries have any “Refresh control,” but the two final tables are set to “Refresh…when opening…” and “Enable Fast Data Load.”
I have a simple UDF (.xlam) “add-in” with about 10 lines of VBA code that sets the X- and Y- axis minimums and maximums for graphs.
It takes just about as long to connect without the UDF as it does with the UDF.
I’ve gone through many of the online videos and articles to help speed up a query.
I’m on Build 26100.1150 ge_release, running a Dell Latitude 7340 64-bit processor with 16 GB of memory.
I’d love the help and advice of this community. Thanks in advance.
It takes 2 minutes to connect to two Power Query tables in a 724 KB Excel file. The source data comes from two Excel files: the first Excel file is 10.3 MB and has five tables used in subsequent queries; the second is 388 KB of raw data. The two “final” tables are fed by 9 “connection only” or feeder queries with five different merges.One of the final tables is 1,860 rows and the other is 730 rows. There is nothing especially fancy or complicated in any of the Queries except for “pivots.” None of the “connection only” queries have any “Refresh control,” but the two final tables are set to “Refresh…when opening…” and “Enable Fast Data Load.” I have a simple UDF (.xlam) “add-in” with about 10 lines of VBA code that sets the X- and Y- axis minimums and maximums for graphs.It takes just about as long to connect without the UDF as it does with the UDF. I’ve gone through many of the online videos and articles to help speed up a query. I’m on Build 26100.1150 ge_release, running a Dell Latitude 7340 64-bit processor with 16 GB of memory. I’d love the help and advice of this community. Thanks in advance. Read More
