SAP Connect With Power BI

[ericx]

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. 

[anupamj]

You might like this PowerBI/ SAP (available for free trial on Azure marketplace): 

https://azuremarketplace.microsoft.com/en-us/marketplace/apps/ecoservity.peopleatwork4pbi?tab=Overvi...

[v-easonf-msft · Accepted solution]

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

[Wonderer_164842]

Hi,

None of these worked.

[amitchandak]

@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-bw

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

https://blogs.sap.com/2012/10/26/step-by-step-guide-to-build-an-odata-service-based-on-rfcs-part-1/