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 ?