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
MFester's avatar
MFester
Frequent Visitor
7 years ago

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.

 

 

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

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,

  • MFester's avatar
    MFester
    Frequent Visitor
    7 years ago

    Thank you v-jiascu-msft

     

    But if I add them manually, then how do I get them into the same datasource instead of multiple.

    I assume thats what I need to compare month after month?

     

     

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

      Hi MFester,

       

      What did you mean "get them into the same datasource instead of multiple"?

      Maybe you can name the file with dates and then use the Folder connector.

       

      Best Regards,

      • MFester's avatar
        MFester
        Frequent Visitor
        7 years ago

        Thanks again for helping me.

         

        Maybe I still can't explain myself very well.

         

        The table in PDF is like this

         

                       Sales          Customers           Employess

        North      411               etc

        South     564

        East        7965

        West      7984

         

        next month I get a new PDF with the same figures in.

         

        What I want to do is to be able to see a graph of for example sales over time - compare different months to each other and so on.

         

        If I load in the tables one after the other I get multiple sources, but I cant seem to get them to work together, so that I can do that.

         

        I have recently made the shift to PowerBI from Tableau and in Tableau I would have merged the data, but I dont know if PowerBI can do that and if so, how?


        Perhaps there is a better way, that I dont know.

         

        Hopefully it's a better explanations.


        Thank you in advance for your help and patience :)

         

        Kind Regards