Forum Discussion
Importing Pdf Table from web url using Python , but it is not stored as dataframe in PowerBI
Hi Pandadev ,
You can use Python to get the table in PDF and export the table, and then select the appropriate connector in power Bi to connect the export file.
http://theautomatic.net/2019/05/24/3-ways-to-scrape-tables-from-pdfs-with-python/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks , yes that works fine for this pdf , but when I import a pdf where I only want certain tables , how can I merge all those selected tables to one table. all the selected tables will have the same structure , column order etc.
Hi Pandadev ,
Based on your description. You can get this PDF file using the web connector.
let
Source = Pdf.Tables(Web.Contents("https://www.caas.gov.sg/docs/default-source/pdf/singapore-registered-aircraft-engine-nos---apr-2020d1324ca0a72f4d42bd40c25673b42c82.pdf-is-not/td-p/1121450"), [Implementation="1.1"]),
Table001 = Source{[Id="Table001"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Table001, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"NO.", Int64.Type}, {"TYPE", type text}, {"REG", type text}, {"OPERATOR", type text}, {"ENGINE TYPE", type text}})
in
#"Changed Type"Use append queries to append more tables.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks , here is an example where I only need selected tables from the pdf - http://inaca.or.id/wp-content/uploads/2019/07/CAR19.pdf
where the column headers are the same as below , is this possible
is there a way to create just one table which has tables containing the correct columns , as the powerbi is pulling in lot's of tables that are not required. was wandering if i could say if the table contains the column headers then add it.
