How to extract Invoice Data from 1000 pdf files into Power BI

[@sonjaboes3138]

Thank you so much for your video and explanation. It's really very useful to me. 💝

[@oleksijm]

Nice. It would be cool if you could show a similar technique to be applied in an Excel Power Query (preferably written directly inside VBA).

[@ericet19]

Great trick ! Thank you

[@jacquesbruneau4371]

Hello.. interesting! however all files have the same format.. for an AP app we would have different pdf file formats so the combine would probably not be functiomning properly. The idea is however clever! Thanks

[@chahramanehafid160]

Wonderful Job , my question is that function in the free version of power BI

[@danwe5520]

yes it is. thanks for watching and (hopefully subscribing to my channel) br and take care

[@reinacp140]

Great video! I recently implemented the same solution for a report that my boss asked me to do out of a pdf file that he receives daily... My concern is, that eventually I will have so many files that the query might struggle combining and transforming everything... So maybe it will be better to work on the data first, with phyton perhaps? And let powerbi only care about reporting?... What do you think? And if you can do a video with that solution it will be awesome!!!

[@danwe5520]

Hi Power Bi should be able to handle quiet a lot of data but if you can "preprocess" the data using Python or other language first then this can make sense indeed. Thanks for your comment and suggestion. I keep that in mind best regards, thanks for watching and (hopefully) subscribing and have a great weekend Dan

[@ashwinkumar5223]

Very Superb. Can you share sample files to try ? Thank you

[@danwe5520]

The files are part of another course and not available sorry. However there should be some demo files if you search for invoices on the web. br and take care

Thanks great video, but I have this problem, I have different pdf files, these have different pages and tables, it may be possible to get the names of the queries so my query does not fail, since the files differ in pages and tables and my query fails

[@danwe5520]

Hi José, hope you are doing well. That would probably require some kind of loop or additional tool. Maybe you can group your file and then do it for each group where the file structure is the same br

[@dxterz]

What is the name of the program?

[@danwe5520]

Power BI Desktop Best regards