Forum Discussion

Amiregent's avatar
Amiregent
New Member
10 years ago
Solved

PDFs as a data source

Would anyone have suggestions as to how one could extract data from PDF pages which can then be used in Power BI?
Need Help
  • mllopis's avatar
    mllopis
    10 years ago

    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.

mike_honey's avatar
mike_honey
Memorable Member
10 years ago

Word 2013+ can open PDF files and does a reasonable job of interpreting their tables etc.  From there I would copy and paste the data into an Excel file get a consistent set of rows and columns.  Whole tables should come across quite easily.

 

If this was a regular requirement, you could probably record/write a Word macro (VBA) to automate the steps.