Power Query data source connection

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