Save 10 HOURS with this Data Automation Project - SAP to Power BI

Join my FREE newsletter to access all resources used in this video: 👉 https://joelting.com/newsletter-downl... 0:00 Introduction & Overview of automation components 2:59 Python scripts and modules 3:29 SAP GUI automation with Python 5:15 SAP AFO workbook refresh automation with Python 7:31 Loading refreshed data into Database with Python 09:05 Power BI Refresh with Power Automate and Python 09:38 Combining all python scripts everything together 11:42 Database configuration and views 12:39 Power BI connection to SQLite 13:32 Conclusion and future video topics Automate Your SAP to Power BI Data Pipeline with Python Discover how to create a powerful, time-saving automation that fetches data from multiple SAP sources and refreshes your Power BI dataset with a single line of code. In this comprehensive tutorial, I'll walk you through: • Extracting data from SAP GUI, SAP Business Warehouse, and APIs • Using Python to automate SAP GUI and SAP Analysis for Office • Creating a SQLite database for efficient data storage • Setting up Power BI to connect with your SQLite database • Implementing secure credential management with KeePass • Triggering Power BI refreshes automatically without API Learn how this automation saved me hours every week and revolutionized my department's data workflow. #PowerBI #SAP #DataAutomation #Python #FinanceTech #datapipeline #nontech DISCLAIMER: SAP® and SAP GUI Scripting are registered trademarks of SAP AG. I am NOT associated with SAP AG in Germany or any other country. I am NOT SAP Partners. I do NOT offer live SAP Training. I do NOT offer SAP Access. We do not recommend the use of SAP Access from any particular provider. MY FAVOURITE TOOLS & GEAR: 📝 Notion - How I Manage My Day - https://affiliate.notion.so/hpemzmxen3jq MY OTHER SOCIALS: 🌍 My website / blog - https://joelting.com/ 🐦 Twitter -   / joelting92   🏢 Linkedin -   / joel-ting   🙎🏻‍♂️ WHO AM I: I'm Joel, a Regional Finance Controller working in Singapore. I make videos about technology, automation and productivity. 📧 GET IN TOUCH: If you'd like to talk, I would love to hear from you. Email me directly at [email protected] would be the quickest way to get a response. I will try my best to reply to your email as soon as possible. P.S. Just a heads up, I receive a kickback from some of the links in this description as they are affiliate links 😜