import data of multiple PDF files to opened file from folder

[abdo meghari]

is there any way to import data of multiple PDF files to opened EXCEL file from directory without specify the file name as in bold line .

so I want just change this line

let
    #"‏‏source" = Pdf.Tables(File.Contents("C:\Users\MY-NAME\Downloads\MMS\PR-2023-00001 (1).pdf"), [Implementation="1.3"]),
    Table001 = #"‏‏source"{[Id="Table001"]}[Data],
'rest of the  procedures
'

'

like this
"C:\Users\MY-NAME\Downloads\MMS\
indicate where are the PDF files are existed in folder and each PDF file import from the folder for each sheet separately in opened EXCEL file .
thanks

 

[jdellasala]

is there any way to import data of multiple PDF files to opened EXCEL file from directory without specify the file name as in bold line .

so I want just change this line

let
    #"‏‏source" = Pdf.Tables(File.Contents("C:\Users\MY-NAME\Downloads\MMS\PR-2023-00001 (1).pdf"), [Implementation="1.3"]),
    Table001 = #"‏‏source"{[Id="Table001"]}[Data],
'rest of the  procedures
'

'

like this
"C:\Users\MY-NAME\Downloads\MMS\
indicate where are the PDF files are existed in folder and each PDF file import from the folder for each sheet separately in opened EXCEL file .
thanks

Don't know where you got that code, but it wasn't generated by Power Query. the first line of a PQ generated Query is ALWAYS "Source =". It would NEVER be #"source" as the #"" is only needed when there's a SPACE in the step name.
Use the UI Interface. Go to Data -> Get Data -> From File.. From Folder.

 

[abdo meghari]

thanks
it imports details file name, directory ...., not data inside the file .

this is the whole code

let
    #"‏‏المصدر" = Pdf.Tables(File.Contents("C:\Users\MY-NAME\Downloads\tt\PR-2023-00001.pdf"), [Implementation="1.3"]),
    Table001 = #"‏‏المصدر"{[Id="Table001"]}[Data],
    #"الرؤوس التي تمت ترقيتها" = Table.PromoteHeaders(Table001, [PromoteAllScalars=true]),
    #"النوع المتغير" = Table.TransformColumnTypes(#"الرؤوس التي تمت ترقيتها",{{"Sr", Int64.Type}, {"Item Code", type text}, {"Description", type text}, {"Purchase Order", type text}, {"Accepted#(lf)Quantity", type text}})
in
    #"النوع المتغير"

the language is not English in excel , I try writing English that's why shows error.

 

[jdellasala]

The data - FILES - are in the Content column.

You "Open" them by clicking on the double down arrows at the top right corner of the column.

 

[abdo meghari]

this is really helpful !
would you tell me how select for each file by import data for each sheet individually . now it will import all of data for all of the files in one sheet , I don't wanted . I want each file should be in each sheet separately .