cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lesteryo
Regular Visitor

SAP BW Connection

Hello.

 

I am new with connecting to SAP BW.

 

I already read post about SAP BW on the link below but still failed and still got an error.

 

http://community.powerbi.com/t5/Integrations-with-Files-and/SAP-BW-Connector-SAP-NetWeaver-library-S...

 

xcv.png

 

Is there a pre-requisite for this? Like an app that needs to be installed on my PC on where the PowerBI Desktop is installed?

 

Any help will be much appreciated.

 

Thanks,

 

Lester

 

2 ACCEPTED SOLUTIONS
v-yuezhe-msft
Microsoft
Microsoft

@Lesteryo,

Have you installed the SAP NetWeaver library on your PC? Make sure the architecture for the SAP NetWeaver library (32-bit or 64-bit) matches your Power BI Desktop installation, then install all files included in the SAP NetWeaver RFC SDK according to the SAP Note.

In other words, when you use 64 bit Power BI Desktop, you would need to install 64 bit  SAP NetWeaver library, when you use 32 bit Power BI Desktop, you would need to install 32 bit  SAP NetWeaver library. Also ensure that you use the latest version of Power BI Desktop, which is available in this link.

Reference:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sap-bw-connector/


Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Blackjack
Frequent Visitor

If you are wondering where the SAP Netweaver RFC SDK library should be installed, the correct procedure is to simply copy the dll files contained in the SDK library into the C:\Windows\System32 folder, given you are running Power Bi Desktop on Windows.
 

After you get the SAP Netweaver RFC SDK library 2 .SAR files from Sap Support Portal as described in SAP Note #1025361, extract them to any temp folder using SAPCAR.EXE, which is also obtained from SAP Support Portal. Go into the folders and copy the dll files from the lib folder C:\Windows\System32.

Next open Power BI Desktop, click on 'Get Data' and select 'SAP Business warehouse Server'. The interface to connect to SAP BW server should be available now. If you are planning to use Data Gateway, you shold also copy the SAP RFC SDK dll files to folder C:\Windows\System32 in the machine you are running the gateway.

  

View solution in original post

7 REPLIES 7
Rquant
New Member

I am currently creating dashboards for a significant procurement/supply chain operation. I have investigated a lot of the commercial vendors for spend analysis such as SpendHQ, Invalua, PRM 360, GEP Smart, Seivo, Coupa, Claritum, Suplari, Zycus.

We use SAP Business warehouse for our procurement data, and I've been using SAP Analysis for Office. I've got a pretty extensive background in data analytics, Power BI, ML, etc. but I have never worked with the SAP BW to Power BI connector. I have heard/read; there are limitations to this connection. (Not all features, data available, etc.)

 

Has anybody here worked with it enough to have an informed (or uninformed) opinion on the viability of building the spend analysis piece in Power BI with the SAP BW connector?

 

The commercial solutions are hundreds of thousands of dollars a year, and they don't seem that advanced to me. Lots of data ETL, clustering for category analysis, and some spend analytics AI algorithms to help identify areas of opportunity. (like rouge spending, soon to expire contracts, anomaly/fraud detection and the like)

 

Thoughts, opinions, feedback, suggestions?????

 

Thanks in advance!

Blackjack
Frequent Visitor

If you are wondering where the SAP Netweaver RFC SDK library should be installed, the correct procedure is to simply copy the dll files contained in the SDK library into the C:\Windows\System32 folder, given you are running Power Bi Desktop on Windows.
 

After you get the SAP Netweaver RFC SDK library 2 .SAR files from Sap Support Portal as described in SAP Note #1025361, extract them to any temp folder using SAPCAR.EXE, which is also obtained from SAP Support Portal. Go into the folders and copy the dll files from the lib folder C:\Windows\System32.

Next open Power BI Desktop, click on 'Get Data' and select 'SAP Business warehouse Server'. The interface to connect to SAP BW server should be available now. If you are planning to use Data Gateway, you shold also copy the SAP RFC SDK dll files to folder C:\Windows\System32 in the machine you are running the gateway.

  

mnemet
Frequent Visitor

Could you please explain the procedure how to extract .SAR files using SAPCAR.EXE? I have dowloaded version 7.20 to my computer. I have two files NWRFC_45-20004568 and NWRFC_45-20004568.SAR. Thank you for your help.

Anonymous
Not applicable

can you please share the "NWRFC_45-20004568.SAR" file with me? So i can help you

mnemet
Frequent Visitor

Hi,

 

Here is the link where you can check the file. Many thanks for your help.

 

https://www.dropbox.com/sh/5dpb8viydh84hws/AADpfWBCISKoHRJVWmcRoGPCa?dl=0

Anonymous
Not applicable

Thank you mnemet,

Question #1 - is this file for Windows 64Bit or Windows 32Bit? I need both versions please

Question #2 - do you have SAPCAR.EXE file as well? if yes could you please share it too?

Rgds,

v-yuezhe-msft
Microsoft
Microsoft

@Lesteryo,

Have you installed the SAP NetWeaver library on your PC? Make sure the architecture for the SAP NetWeaver library (32-bit or 64-bit) matches your Power BI Desktop installation, then install all files included in the SAP NetWeaver RFC SDK according to the SAP Note.

In other words, when you use 64 bit Power BI Desktop, you would need to install 64 bit  SAP NetWeaver library, when you use 32 bit Power BI Desktop, you would need to install 32 bit  SAP NetWeaver library. Also ensure that you use the latest version of Power BI Desktop, which is available in this link.

Reference:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sap-bw-connector/


Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.