1 min readfrom 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?

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

Want to read more?

Check out the full article on the original site

View original article