Forum Discussion
SAP Connect With Power BI
I need to connect the SAP with Power BI. is there any possibility to connect the Power BI and SAP without SAP Connectors or Should I need to get the SAP Connector.
Hi, ericx
If you are trying to connect to SAP BW ,Power BI will requirest SAP .NET Connector 3.0 to be installed,
otherwise you will have to use the NetWeaver RFC connection and select implementation 1.0.
Use the SAP Business Warehouse connector in Power BI Desktop
If you are trying to access SAP HANA datbase, you must have the SAP HANA ODBC driver installed on the local client computer for the Power BI Desktop's SAP HANA data connection to work properly. You can download the SAP HANA Client tools from SAP Development Tools, which contains the necessary ODBC driver.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-sap-hana
You also can check this post.
Microsoft Power BI on top of SAP Data sources : a winning combo ?
sap-bw-demo-and-microsoft-powerbi-desktop.-step-by-step-guide
Best Regards,
Community Support Team _ Eason
6 Replies
ericx , These are various article on ways you can connect to SAP
https://blogs.sap.com/2018/10/02/sap-bw4hana-connectivity-options-in-microsoft-power-bi/
https://blogs.sap.com/2020/01/30/sap-bw-demo-and-microsoft-powerbi-desktop.-step-by-step-guide/
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-sap-hana
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-sap-bwhttps://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-combohttps://blogs.sap.com/2012/10/26/step-by-step-guide-to-build-an-odata-service-based-on-rfcs-part-1/
Hi, ericx
If you are trying to connect to SAP BW ,Power BI will requirest SAP .NET Connector 3.0 to be installed,
otherwise you will have to use the NetWeaver RFC connection and select implementation 1.0.
Use the SAP Business Warehouse connector in Power BI Desktop
If you are trying to access SAP HANA datbase, you must have the SAP HANA ODBC driver installed on the local client computer for the Power BI Desktop's SAP HANA data connection to work properly. You can download the SAP HANA Client tools from SAP Development Tools, which contains the necessary ODBC driver.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-sap-hana
You also can check this post.
Microsoft Power BI on top of SAP Data sources : a winning combo ?
sap-bw-demo-and-microsoft-powerbi-desktop.-step-by-step-guide
Best Regards,
Community Support Team _ EasonYou might like this PowerBI/ SAP (available for free trial on Azure marketplace):
Hi ericx
Native SAP BW connectivity requires SAP .NET Connector 3.0/3.1, while SAP HANA connectivity requires the SAP HANA ODBC driver.
If your source is SAP S/4HANA, you may also evaluate Power BI Connector for SAP:
It uses SAP OData services and provides Power BI with an OData endpoint, without requiring SAP .NET Connector or HANA ODBC on developer machines.
Documentation:
https://metricasoftware.com/docs/sap/Cheers,
Metrica TeamFor streaming SAP TCODES, reports or tables (HANA or any DB), you may use this solution on Azure Marketplace :
https://marketplace.microsoft.com/en-us/product/ecoservity.peopleatwork4pbi
