Forum Discussion

pbi1908's avatar
pbi1908
Helper III
3 years ago
Solved

Get data from a PDF with a scanned document

Hi i received some pdfs in daily basis with some tables.    Some of them are within PDF so i can import the information in the Power BI but some of them they have some scanned documents so the norm...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi pbi1908 ,

    If I understand correctly, it seems that you are trying to connect to PDF file. But it is a scanned PDF file, and Power BI can't read the data successfully from it. You can refer the following links to connect the normal PDF file in Power BI Desktop.

    Connect to PDF

    Read and Import Data from PDF Files using Power BI

    And for the "special" PDF, please review the last reply in the following thread. And check if we can convert that PDF file to the normal one first by some one tool first. 

    Data extraction from Scanned PDF document

    Best Regards

takolota's avatar
takolota
Frequent Visitor
3 years ago

If anyone wants to extract data from a PDF or image without training a model for select documents, try this new GPT data extraction method: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Extract-Data-From-PDFs-and-Images-With-G...

 

It doesn’t require specifying certain document areas, wordings, styles, etc. It just OCRs the file, converts it to a replica text (txt), and passes it to a GPT prompt where you can ask GPT to do whatever you want with the document data.