How to auto set data source path in power query excel

[RPA_PowerBI]

Hello,

I have a macro excel sheet where i have created  some query datas , when i share the sheet with others they need to change the input data source settings to set the path for the input file. Is there a way to auto set/dynamic path setting tricks available to set the data source path???

[ImkeF · Accepted solution]

Hi @RPA_PowerBI ,
this is described here: Create Dynamic File Path in Power Query - Goodly