Power Query data source connection

Highlighted
Regular Visitor

 

Dear community,

 

I have 10 files connected to one excel file (master data) by using a power query connection. When I am refreshing any file, I got automatically the latest updated data from the source (the master data is on a SharePoint site).

 

My issue : I have 4 connection per file (4 sheets from the master data), and the refreshing is taking to much time due to the several connection.

 

  • Do you know if there is a way to have only 1 connection and import the different sheets from source ?
  • Do you have a better suggestion to connect these file to the same master file ?

 

I would appreciate any help.

 

Thank you in advance.

 

 

0 Replies