Connect Power BI desktop to SAP ECC 6

[mnada80]

Dear All,

I need to connect to SAP ECC6 EHP 6 what is the best way other than BW which works well but I need real-time data. I am not going to do many reports it is only one report and that will not affect the performance. 

Regards

Mamdouh Nada

[anupamj]

Hello @mnada ,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

Besides realtime in PowerBI, you may also provision SAP data to a datalake/ DB / NFS & consume from there.

This is certified by SAP & Microsoft:  USB4SAP - Connectors | Microsoft Learn.

hope this helps. 
AJ

[v-deddai1-msft · Accepted solution]

Hi @mnada80 ,

Power BI does not support get real-time data from SAP ECC now. Please refer to https://businessintelligist.com/2017/04/11/power-bi-and-sap-what-works-and-what-doesnt/. I suggest you create an idea for it in idea forumn: https://ideas.powerbi.com/forums/265200-power-bi-ideas

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

Best Regards,

Dedmon Dai

[mnada80]

Thank you very much for the reply,

now I want to ask you when we talk about SAP HANA are we talking about S4HANA or SAP on HANA database is enough

[amitchandak]

@mnada80 , refer if these can help

https://www.youtube.com/watch?v=y3se-VEDvqU
https://www.youtube.com/watch?v=ncNmrPamRSg
https://answers.sap.com/questions/675539/integrate-sap-ecc-to-power-bi.html
https://www.element61.be/en/resource/microsoft-power-bi-top-sap-data-sources-winning-combo