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

Book a call with me:
👉 https://joelting.com/book-a-call/

📧 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 😜