topic Re: Connecting SAP Reports to Power BI as data source in Desktop

Connecting SAP Reports to Power BI as data source

Shishir22 — Tue, 22 Jun 2021 13:57:28 GMT

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!

amitchandak — Tue, 22 Jun 2021 14:01:27 GMT

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

Shishir22 — Tue, 22 Jun 2021 14:10:58 GMT

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

v-xiaotang — Thu, 24 Jun 2021 08:08:33 GMT

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

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.

anupamj — Sun, 17 Mar 2024 23:59:33 GMT

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