Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello Community,
We have a Netweaver 740 GUI in our office that IT does only give us access to be able to run transactions and save reports. As I have seen many times people use the recorded scripts using SAP record automation feature and bring it to Excel VBA using Macro to automate the process, I was wondering if there is a way to use the same scripts in POWER BI or POWER QUERY and imitate the automated Macro job as in EXCEL?!
need really a help
many thanks
Did I answer your question? Mark my post as a solution.
Proud to be a
Datanaut! Appreciate your Kudos Smiley Happy
Hi @Anonymous ,
It is easier for power bi to get data from API/build-in Connector/R Script, but it is hard to get data from GUI using Macro, maybe you could try to get data from the excel file which you can use macro scripts to import data from SAP Netweaver GUI.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.