Power Query data source connection

%3CLINGO-SUB%20id%3D%22lingo-sub-1536852%22%20slang%3D%22fr-FR%22%3EPower%20Query%20data%20source%20connection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1536852%22%20slang%3D%22fr-FR%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDear%20community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%2010%20files%20connected%20to%20one%20excel%20file%20(master%20data)%20by%20using%20a%20power%20query%20connection.%20When%20I%20am%20refreshing%20any%20file%2C%20I%20got%20automatically%20the%20latest%20updated%20data%20from%20the%20source%20(the%20master%20data%20is%20on%20a%20SharePoint%20site).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3EMy%20issue%3A%3C%2FU%3E%20I%20have%204%20connection%20per%20file%20(4%20sheets%20from%20the%20master%20data)%2C%20and%20the%20refreshing%20is%20taking%20to%20much%20time%20due%20to%20the%20several%20connection.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EDo%20you%20know%20if%20there%20is%20a%20way%20to%20have%20only%201%20connection%20and%20import%20the%20different%20sheets%20from%20source%3F%3C%2FLI%3E%3CLI%3EDo%20you%20have%20a%20better%20suggestion%20to%20connect%20these%20file%20to%20the%20same%20master%20file%3F%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20appreciate%20any%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1536852%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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