Forum Discussion
PDFs as a data source
Amiregent,
There's currently no solution to import PDF data into Power BI Desktop. This data source is in our radar, as we have received some requests in the past, but we don't have any immediate plans to add it to the product.
If this is an important feature for you, please leave a vote for it in our UserVoice Feature Suggestions forum. Please also leave a description about the type of data that you need to extract from the PDF document. For instance, are you trying to extract one/multiple tables from the document, or plain text?
Thanks,
M.
Just to close the loop on this request: importing from PDF files is currently a preview feature in Power BI Desktop. Please try it out and let us know what you think!
Ehren
As the new release has made the PDF connector a GA, I was wondering the following:
Is there a function or script that can make extraction from PDF tables values automatic? such as data scraping from HTML websites but for a bluk of PDFs files?
such as;
If I select a folder with PDFs, can it look for tables in all containing the referenced values/words and only download those tables (automatically) ?
I haven't found a function that enables such.
Does anyone have any advice?
Jam54 ,
to my knowledge, all tables would be downloaded and then you can filter after their content.
Just create a table with one URL in each row and add a column where you extract all tables first. Then add another column that filters the column with the list of tables (use Table.Contains if you want to search for a word in all columns)
Anyone know when this functionality will be available for power query in excel?
Hi,
My team is currently working on this. I hope the PDF connector in Excel will be available for Office 365 subscribers earlier next year.
Guy
- Excel Team
