1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

PowerQuery takes an extremely long time to load intermediary steps.

I have a PQ that I use regularly that takes about 5 minutes to refresh from start to finish. Recently I’ve been doing some development/ bug fixing and when trying to look at some of intermediary steps, the tables are taking >5 minutes to load. What could be the cause of this?

submitted by /u/xFLGT
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#real-time data collaboration
#real-time collaboration
#PowerQuery
#loading
#refresh
#intermediary steps
#development
#bug fixing
#tables
#data processing
#Excel
#performance
#execution time
#efficiency
#performance issues
#optimization