Forum Discussion

zwie's avatar
zwie
Frequent Visitor
4 years ago

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...
Need Help
otravers's avatar
otravers
Icon for Community Champion rankCommunity Champion
4 years ago

Can you show the Source step of your queries?

zwie's avatar
zwie
Frequent Visitor
4 years ago

All of my queries have something similar to

 

Source = Excel.CurrentWorkbook(){[Name="Table24"]}[Content]

 

Where the "Table24" is where I put my input table.

Sometimes I pull multiple tables from the workbook so I might have a similar line with SourceB but most of the time I am pulling one table a single time.

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi 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

    • zwie's avatar
      zwie
      Frequent Visitor
      4 years ago

      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.