topic Re: Connecting Power BI to SAP in Desktop

Connecting Power BI to SAP

Anonymous — Wed, 29 Jun 2022 17:30:52 GMT

I want to develop a report in Power BI, the legacy system is SAP, i want to know if there any pros & cons for using SAP ByDesign Connector instead of SAP HANA?

Please i need help with this.

Re: Connecting Power BI to SAP

Anonymous — Mon, 04 Jul 2022 06:51:52 GMT

Hi Anonymous

There are two versions of connectors,1.0 Sap BW connector and 2.0 Sap BW connector. We suggest you use the Implementation 2.0 SAP Connector whenever possible.

I think you may refer to the offical blogs to learn how to use SAP BW connector in Power BI Desktop.

For reference:

Use the SAP Business Warehouse connector in Power BI Desktop

You may refer to below offical blogs to learn more details about the differences between SAP BW and SAP HANA.

Connect to SAP Business Warehouse by using DirectQuery in Power BI

Connect to SAP HANA data sources by using DirectQuery in Power BI

Best Regards,
Rico Zhou

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

Re: Connecting Power BI to SAP

Tornally97 — Thu, 18 May 2023 22:54:58 GMT

There is an easy solution to this. Simplement, a Microsoft Partner, offers an event-driven platform that reads SAP HANA tables in real-time, and can give you access to any of the SAP tables you need. No need to go to the Calculation views, or to any BW Objects, get the table data dirctly, and instantly. They are at www.Simplement.us

Re: Connecting Power BI to SAP

anupamj — Mon, 11 Sep 2023 20:05:14 GMT

Hello,If PowerBI needs to fetch data directly from SAP (say reports, queries, tables, views, CDS, BW extractors 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

Re: Connecting Power BI to SAP

anupamj — Mon, 29 Apr 2024 20:23:38 GMT

here's the video guide: https://youtu.be/im4ngdboJvQ