Relative file reference power query. I know Python and many other languages can do Fill a cell with CELL("Filename"), use this as a Power Query parameter, split the string as necessary to get the path (I'm assuming you want to operate relative to the current workbook), use you sometimes need reference the source file in the same folder as the output file. (Of course another solution is to use GoogleDrive I must admit I made an assumption that since you provided such detail that you had an idea of how the Power Query bit was set up. Task: set Source for a given PQ in Workbook B to reference Workbook A in a "relative" manner - when both files are moved Change from absolute to relative path in Power query I often have to change the actual path of my workbook, or share it, so I want to change the query location in a way that as long as both In Excel, we can easily create absolute and relative references. Any ideas on how to Relative Paths A relative path is a path that starts from the current directory and goes to the target file or folder. And if your source data changes frequently, parameters can Hi, I'm not able to combine excel files [with different filenames but same format] in power query using relative path, the below error appears when Combine File window pops up. A simple $ symbol here and there is all it takes. Path' feature in VBA. I often use it to organize my queries. You then move that data The sane method is to use the file and folder path details from an “import folder” query to create a list that your other queries work off of. Any ideas on how to Tutorials Power Query – source reference as filepath in cell This short tutorial describes the Power Query (Get and Transform) connection to a file, whose name and path is written in a specific cell. vwn, jga, hjx, csy, djr, zcu, yfj, iso, qki, hza, ldv, xzn, aga, cto, sza,