Forum Discussion

misen13's avatar
misen13
Frequent Visitor
7 years ago
Solved

Dynamic folder location

Hi, I'd like to know if there is a way to dynamically set a folder path if I have to update all the Excel files in the folders every week? IE: On my desktop, I have a folder named: KPI. KPI has...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    misen13 v-cherch-msft

     

    I think this there is another way to make folder dynamic

     

    This is via an Excel Table or Named Range

     




    Now in your query you can define the folderpath which is linked to a Cell in ExcelTable

    let

FolderPath= Excel.CurrentWorkbook(){[Name="FolderDefinition"]}[Content]{0}[Column1],
Source = Excel.Workbook(File.Contents(FolderPath & "FileName.xlsx"), null, true),
MyTable = Source{[Item="Table1",Kind="Table"]}[Data]
in
    MyTable





     

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    7 years ago

    misen13 v-cherch-msft

     

    I think this there is another way to make folder dynamic

     

    This is via an Excel Table or Named Range

     




    Now in your query you can define the folderpath which is linked to a Cell in ExcelTable

    let

FolderPath= Excel.CurrentWorkbook(){[Name="FolderDefinition"]}[Content]{0}[Column1],
Source = Excel.Workbook(File.Contents(FolderPath & "FileName.xlsx"), null, true),
MyTable = Source{[Item="Table1",Kind="Table"]}[Data]
in
    MyTable