Relative path for Combine & Load|Power Query|Excel Forum|My Online Training Hub

Hi everyone,

I am trying to create a relative path to perform a combine & load for multiple Excel files in a folder. I've been able to create relative paths for a single workbook, but I can't get the functionality the same for a relative path to a folder. Below is what I have: 

I have a "GetValue" function;

(rangeName) =>
Excel.CurrentWorkbook(){[Name=rangeName]}[Content]{0}[Column1]

Which I use in the query below to import a specific file using a relative path; 

let
Source = Excel.Workbook(File.Contents(GetValue("MyExcelFileDataPath"))),
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],

where "MyExcelFileDataPath" is a named cell which contains the full data path. 

But I want to use a similar relative path, instead of the static path that is present in my combine & load query; 

let
Source = Folder.Files("C:\Users\abc123\Reports\Reports Are Located Here"),

I've tried using the GetValue function and another named cell with the full data path (something like the below), but it doesn't work; 

let

Source = Folder.Files(GetValue("Data path to report location"))

Power Query doesn't seem to recognize the use of GetValue to name the relative path for my folder files. Is there a way to use a relative path specifically for combining & loading a folder? 

Thanks!