•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power Query refresh speed with multiple users
Hello all.
I have a report that has multiple queries with data sources saved in SharePoint. Enable Fast Data load is checked in all the queries.
There are about 10 users, with reported run time of around 5-10 minutes. But for me and one user, it takes 30-60 minutes to finish refreshing.
I have already made some improvements in the initial code, and did a clean up of old raw data files in SharePoint but this resulted to minimal improvements.
Given that all users have the same laptop configurations and are connected to the same internet connection, what are some steps I can do to do improve the speed on the queries?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#real-time data collaboration
#big data management in spreadsheets
#conversational data analysis
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#Excel compatibility
#no-code spreadsheet solutions
#real-time collaboration
#Excel alternatives
#Power Query
#SharePoint