Connecting SAP Reports to Power BI as data source

[Shishir22]

Hello All,

Is there any way by which we can use SAP reports as a Data Source to Power BI Reports? I have minimum unserstanding about SAP.

I am able to connect to underline tables used to create SAP reports with help of SAP HANA DB Connector.

Just want to know if there is any way to fetch output of SAP reports as input to Power BI.

Any help will be appreciated.

Thanks in Advance!

[anupamj]

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

ALV, standard and custom reports are supported out of the box.

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

[PS] Step by step Video guide is here: https://www.linkedin.com/feed/update/urn:li:activity:7174406748747833344/

[v-xiaotang]

Hi @Shishir22 

I find several links about SAP for you reference, please refer to:
Connect to SAP HANA databases in Power BI
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-sap-hana

Connect to SAP Business Warehouse by using DirectQuery in Power BI
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-sap-bw

Hope it helps!

Best Regards,

Community Support Team _ Tang

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

[Shishir22]

Hello @amitchandak ,

I want to connect to output of SAP Reports directly as a source to Power BI if possible.

[amitchandak]

@Shishir22 , You do not want to connect power bi with SAP HANA ?

You need to stage report as cvs or excel and source it from there