cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lesteryo Visitor
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

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: SAP BW Connection

@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
Frequent Visitor

Re: SAP BW Connection

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

6 REPLIES 6
Moderator v-yuezhe-msft
Moderator

Re: SAP BW Connection

@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
Frequent Visitor

Re: SAP BW Connection

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

mnemet Frequent Visitor
Frequent Visitor

Re: SAP BW Connection

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.

vuraltuy Frequent Visitor
Frequent Visitor

Re: SAP BW Connection

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

mnemet Frequent Visitor
Frequent Visitor

Re: SAP BW Connection

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

vuraltuy Frequent Visitor
Frequent Visitor

Re: SAP BW Connection

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,

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 1,567 guests
Please welcome our newest community members: