Forum Discussion
PDF data automated
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,
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?
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,
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
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.
Best Regards,