Forum Discussion
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
- 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
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
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)
- I have uploaded the file to my dropbox space now, so the link should remain valid, remember to read the "Readme" file carefully. You should not be creating a seperate folder for the SAP NW RFC files inside the BIN folder, you are supposed to copy the files from the extraced "SAP_NW_RFC" folder, in other words all the files within that new folder. Then put those files into the BIN folder, do not create a folder inside the BIN folder. https://www.dropbox.com/s/d2krzbass1sgcco/SAP_NW_RFC.zip?dl=0
I get the following error while trying to connect. What could be the issue?
Hi there, that looks like an incorrect configuration on the connection while trying to connect to SAP BW.
Please ensure you are using the correct details. You can also try to add the FQDN (Fully Qualified Domain Name) behind the server / hostname, eg: Instead of just using SAPBW01 as your hostname, you would use SAPBW.microsoft.com
Just as an example ^^
If you could, please add me on Skype then I can try and guide you through it. Please just do not call / video call, use only Instant Messaging as I am in meetings most of my day, every day. But I do have my Skype open. Skype ID: [email protected]
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- 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.
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.
I have a same issue.
- I have uploaded the file as well as the readme again. This is another 1 week temporary upload as I am sorting out a permanent upload in the meantime. Link: https://we.tl/jxezYGmoo3
Trying to access this wetransfer page on 9/12, exactly a week after 9/5 and its gone!
I tried to download the nwrfcsdk.zip and create a folder nwrfcsdk inside the Bin folder but it didn't work, Any chance you could upload your writeup once more, please?
Hi everyone,
has anyone of you an Idea which Queries are shown with this connector.
Some Cubes with queries are available some not. Didn't found any rule.
I was hopping I can access all queries which are available with standard SAP front ends like Bex Analyzer or Analysis for Office
Best Regards
Sebastian
