Join my FREE newsletter to access all resources used in this video:
? https://joelting.com/newsletter-download/
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 - https://twitter.com/JoelTing92
? Linkedin - https://www.linkedin.com/in/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 ?