Forum Discussion
Slow "connecting to datasource" step
Hello, I am using power query on excel and I have been trying to speed up my queries but noticed that the "connecting to datasource" step takes a long time when creating and refreshing a connecti...
v-jingzhang
Community Support
Community SupportHi zwie
Where is this Excel file located? Is it on your local drive or on somewhere else e.g. OneDrive, Shared folder, etc.?
Best Regards,
Community Support Team _ Jing
Hello v-jingzhang ,
My file is synced on a OneDrive. I just tried copying the file to a completely local folder on my machine but I get similar problems as before where sometimes a query takes 5-8 seconds and an additional 40 seconds with my vpn.