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.
It is possible to write a VBA procedure to read a PDF file and write selected information to your Excel workbook. With the procedure written, you could create entire tables in Excel from your PDF at the push of a button. Once the information is in Excel, it is available to Power BI.
The type of VBA procedure I have in mind requires you to have, in addition to Excel, Acrobat regular or pro (not Acrobat Reader).
The difficulty of writing the VBA procedure will vary with the PDF file and the information you are wanting to extract from it.