Hi All
I am building a Power Query that holds a dynamic Path to a folder that holds my data input files.
I have managed to set it up so that the path is dynamic.
My big issue is that when i change the path I get an error because the sheet selection is based on the static path given before the change.
How do a make this dynamic???
Issues start in the second line holding a #
I am building a Power Query that holds a dynamic Path to a folder that holds my data input files.
I have managed to set it up so that the path is dynamic.
My big issue is that when i change the path I get an error because the sheet selection is based on the static path given before the change.
How do a make this dynamic???
Issues start in the second line holding a #
Power Query:
let
Source = Excel.CurrentWorkbook(){[Name = "DynamicPath"]}[Content],
Path = Source{0}[Dynamic Path],
GetFolderFiles = Folder.Files(Path),
#"C:\Material_Segmentation\PlantSite Data\_MB51 XLSX" = GetFolderFiles{[#"Folder Path"="C:\Material_Segmentation\PlantSite Data\",Name="MB51.XLSX"]}[Content],
#"Imported Excel" = Excel.Workbook(#"C:\Material_Segmentation\PlantSite Data\_MB51 XLSX"),
Sheet1_Sheet = #"Imported Excel"{[Item="Sheet1",Kind="Sheet"]}[Data],