i am trying to set up a dynamic source iin power query so i can load the filepath and have it go there.

i've been able to do it by placing the filepath into a workbook and then pulling into PQ as a table, and using the drill down.

Renaming the query as Directory (table is called directory as well)

then going into the Advanced editor of the imported data query changing the "c:filepath name" with the directory (see below)

but when i've tried to do the same steps i cant recreate it

is there something i'm missing?

let
Source = Csv.Document(File.Contents(Directory),[Delimiter=",", Columns=2, Encoding=1252, QuoteStyle=QuoteStyle.None])
in
Source