cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rjm900 Frequent Visitor
Frequent Visitor

SAP BW Connector

Hi everyone,

 

Hoping you can help here. I'm trying to get a connection through to SAP BW from PowerBI using the in-built conector. I've succesfully managed to do this previously, using an older version of PowerBI (September if I remember corerctly). The problem now however is that I keep getting an error message saying "Connection String is not Valid", despite all of the credentials being correct (I know this for a fact as I can still log into it fine using an older PBI version).

 

 

Something has clearly changed in the latest Desktop update which is preventing me from accessing BW - any advice would be greatly apprecaited?

 

Regards.

24 REPLIES 24
Moderator v-qiuyu-msft
Moderator

Re: SAP BW Connector

Hi @rjm900,

 

Did you get issue when connecting to SAP BW use Power BI desktop version 2.42.4611.901? Did this new desktop version reside on the same computer host old desktop version? Did the new version desktop and old one are the same bit, for example, both are 64 bit? Please make sure the Server, System Number and Client ID used to establish the connection are the same in those two desktop versions.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JuandreR Frequent Visitor
Frequent Visitor

Re: SAP BW Connector

Hi @rjm900, Have you downloaded and installed the latest SAP NW RFC dll's ? I found this same issue previously and when I installed the latest SAP NW RFC dll's, it fixed the issue for me.
JuandreR Frequent Visitor
Frequent Visitor

Re: SAP BW Connector

For anyone wondering how to get the SAP NW RFC working in Power BI so you can connect to a SAP BW Datasource, download the SAP NW RFC files from the SAP Website (DLL + LIB files). Extract the downloaded file and copy the contents into the BIN folder located inside your Power BI installation directory.
PatriciaH New Member
New Member

Re: SAP BW Connector

Hi JuandreR,

 

Is there anyway to know which version of Netweaver you need? Or is it safe to think you need the latest Netweaver (7.5) if you have the latest update of PowerBI (march 2017) installed?

 

Thanks for any reply.

 

duncangibb New Member
New Member

Re: SAP BW Connector

Id appraciate any help on this too.  I had the same issue, I downloaded all the *.dll and still no luck.  I'm advised by colegues that after navigating "Get Data > Sap Business Warehouse Server" they see a prompt to configure IP address etc.  I never see this and despite searching the app I have not found a place to enter this.  Any clues?

Priyab Frequent Visitor
Frequent Visitor

Re: SAP BW Connector

Hello JuandreR,

 

Can you share a link to the SAP NetWeaver RFC SDK. I am having similar issue. Only that Power BI wont let me pass the initial screen saying i need to install these above files.

Highlighted
JuandreR Frequent Visitor
Frequent Visitor

Re: SAP BW Connector

Here is a link detailing the download & extraction process of the SAP NetWeaver RFC SDK. https://wiki.scn.sap.com/wiki/display/ABAPConn/Download+and+Installation+of+NW+RFC+SDK. One thing to note is that you should not be copying the extracted files to the USR/SAP/ folder as you need the files to be copied into the "BIN" folder in your PowerBI Installation folder. I have also uploaded a compressed version of the required files so that you don't need to use the SAPCAR extraction utility, you can just download the ZIP file from the following link, extract it using any standard ZIP utility, and copy the files into the BIN folder of Power BI. https://files.fm/u/6c7c9mq3
erikskov
Advisor

Re: SAP BW Connector

Quick clarification, copy the entire folder (\nwrfcsdk) into the directory and it will work.  For example:  C:\Program Files\Microsoft Power BI Desktop\bin\nwrfcsdk

 

I also updated the environment path to point the LIB folder under this location :  C:\Program Files\Microsoft Power BI Desktop\bin\nwrfcsdk\lib

 

 

Updated link to NWRFCSDK archive: https://1drv.ms/u/s!Aus5ZoRlQqXmr2iKCG98pLrQuUD4

SASH117 Occasional Visitor
Occasional Visitor

Re: SAP BW Connector

Hi

 

I copied it into the BIN folder, still I get the message "This connector requires one or more additional components"

 

Any idea?

 

i am using: Version: 2.48.4792.721 64-bit (July 2017)

Helpful resources

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.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 115 members 1,675 guests
Please welcome our newest community members: