Power BI > Sap Gui integration

[Anonymous]

Hello, I see there is alot of databases available including SAP Hana and Sap BW but we at the company use Sap GUI Anyone know a way to connect to this? If not, does anyone know an automated workaround such as Power Automate ways.

[TORNALLY]

Hello @DvdH , for extracting SAP data to datalake you may take a look at Simplement's Roundhouse tool.  This SAP-certified facility offers a range of formats, including datalake.  It is built S/4, so no fiddling around with replication.

[Anonymous · Accepted solution]

Hi @Anonymous 

Maybe you can use power automate to extract data  from SAP GUI,  then import data to power bi, power BI cannot connect to SAP GUI directly.please refer to the following link:

Extract data from SAP GUI UI by using Power Automate - Power Automate | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[anupamj]

Hello @Anonymous , if you are using PowerAutomate with SAP then this certified connector will be useful: USB4SAP - Connectors | Microsoft Learn.

If PowerBI needs to fetch data directly from SAP (say reports, queries, tables, views CDS etc) then the USB4SAP connector for PowerBI will be useful: Ecoservity – Ecosystem. Services. Technology

hope this helps. 
AJ

[Anonymous]

Thanks, I used a different method due to my company having a datalake where the data i needed was stored. But im sure this would of worked aswell. Sadly i do not have access to power automate yet.
Thanks anyways!

[anupamj]

Hello @Anonymous , for extracting SAP data to datalake you may use the ADF plug-in for SAP. It allows extraction of SAP reports / other modelled information as well as, tables extraction (with Change Data Capture).  More info is here

[Anonymous]

How can u u do this ?

[anupamj]

Hello @Anonymous , Ecoservity provides the connector for PowerBI to SAP for access to reports & other objects.