EXTRACT DATA from PDF files into POWER BI or EXCEL using POWER QUERY // Beginners Guide to Power BI

In this video were going to look at how you can extract table data from PDFS into Excel or Power BI. We're also going to look at how you can combine multiple PDF files the easy way.
🕓 TIMESTAMPS
0:00 - Intro
00:45 - Getting data from PDF
03:42 - Combining from multiple PDFs
08:15 - Getting invoice dates
-
📣 Get Demo Files HERE
bit.ly/3dJE2O7
🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.
solutionsabroad.thinkific.com/
📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more
solutionsabroad.co.uk/newsletter
🛒 Power BI TEMPLATES and more at our digital shop
solutionsabroad.co.uk/store
ko-fi.com/solutionsabroad/shop
❤ Other ways to SUPPORT us
/ solutionsabroad
ko-fi.com/solutionsabroad
📧 GET IN TOUCH
Website: solutionsabroad.co.uk/
Email: [e-mail]
LinkedIn: / solutionsabroad
Facebook: / solutionsabroad
Instagram: / solutions_abroad
🤝 SOLUTIONS ABROAD
Hi Power BI fans, my name is Fernan. In 2018 I founded Solutions Abroad to help fellow data enthusiasts learn Microsoft’s tool, Power BI. I’m currently based in London with over 8 years of experience working with data and business intelligence. In this channel I provide educational videos about Power BI including tips and tricks, step by step tutorials, news, and all of it for FREE. I also provide some paid content such as courses, templates as well as consultancy services.
If you like what we’re doing here and would like to support, consider purchasing something or donating through our Patreon, every little penny helps us keep the channel going.
🙏 THANK YOU
Thank you so much for checking out my channel and my videos. You, the community, have been instrumental in growing the channel to where it is now. Hope to see you again on my next video!
#PowerBI #DataAnalytics #BusinessIntelligence

[@SKCourier]

I have pdf but sometimes it has 4 columns and sometimes 5 times hence it is not importing properly. I have to manually adjust column. I have around 1000 pdfs

[@hasnahameed]

Same question
Not always in same rows
Row headers and Column Header are not always at the same place 😢