Forum Discussion

MFester's avatar
MFester
Frequent Visitor
7 years ago

PDF data automated

Hi all,  Hopefully you can help me.   Each month I receive a PDF where I want to take one table of data into Power BI. I can use the PDF converter and read the data no problem, but I have two...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi MFester,

 

Power BI has the exact feature. Please refer to the gif animation below. We can combine the source file, PDF here, into a single query. We can get the new data by refreshing the query when new data has been added. I would suggest you name the files with dates. Then we can extract it as the date column.

pdf-data

 

Best Regards,

MFester's avatar
MFester
Frequent Visitor
7 years ago

When I follow your steps it gives me an error.

 

"COMBINE FILES

 

We didnt't recognize the format of your first file (112018.pdf). Please filter the list of files so it contains only supported types (Text, CSV, Excel workbooks, etc.) and try again"

 

What can I do about that?

 

Because looking at the gif, that's exactly what I want.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi MFester,

     

    I would suggest you upgrade your Desktop first. It's version: 2.65.5313.1381 (December 2018) now.

    Can you import 112018.pdf using PDF connector?

     

     

    Best Regards,

  • MFester's avatar
    MFester
    Frequent Visitor
    7 years ago

    Hmm..

     

    I can see the IT department updated to new version - 2.65.5313.1421 (januar 2019). In that version I can't seem to find the PDF connector at all. Has it been removed from the newest version or do I have to do something to get it back?