Forum Discussion
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 questions.
1) Is there any way to automate the proces, so I dont have to manually load up the PDF in Power BI and all that.
2) How do I get some sort of date on the data? Again - with at least manual labour as possible. I can make a new column where I can write for instance 2018 or something, but every PDF opens as a new datasource, and I cant get them to work together. Perhaps they need to be in 1 datasource, but I dont know how to do that.
Hopefully someone can help me.
11 Replies
Hi MFester,
There is a preview feature that can take the PDF as the data source. Please refer to /desktop-connect-pdf.
1. Maybe you don't need a PDF converter anymore.
2. What's the "sort of date"? Where is it from?
Best Regards,
thank you for the answer.
I'm sorry I wasn't clear enough. When I wrote PDF converter, i meant the beta-feature in Power BI.So I can get the data in.
Each month I receive a PDF report with data for the current month. The report is exactly the same each month with differents numbers of course.
There is no indication of time in the data, but maybe I can add a new variable each time i load in the PDF.
What my problem is, is making it into one dataset, so that I can see it over time. Preferably I should just the new months figures to some sort of dataset and then it would run smoothly.
Hi MFester,
Since the Connectors read data from the source, I'm afraid they can't add dates automatically. But you can add them manually.
Maybe you can the Folder connector. You can get the new data by refreshing.
Best Regards,
