Forum Discussion
=Excel.CurrentWorkbook()
How work this function? =Excel.CurrentWorkbook() Which is current workbook? I always got emtpy fields Do i need specify any workbook name and path? Do it take everithing from Activeworkbook?
Analitika , See if this script help
let
path = Excel.CurrentWorkbook(){[Name="lstFile"]}[Content]{0}[Column1],
Source = Excel.Workbook(File.Contents(path), true)
in
Source
Check if this can help
https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi