Read a file path from an Excel range in power query to fix error [Formula.Firewall: Query references other queries, so it may not directly access a data source.]

filepath.ts

/* Use function like this
   Folder.Files(FilePath())
*/

= () => let
        /* Source = File_Path,                                         (Replace this line with the one below) */ 
        Source = Excel.CurrentWorkbook(){[Name="File_Path"]}[Content], // File_Path is range name
        Path = Source{0}[Column1]                                      // Column1 is the name of the source table column  
    in
        Path