What versions of the tools do you have installed. Can you make sure that you have the latest ones (v7.40)? Other than that, did you make sure that the Netweaver components are selected in the installation?
I found my issue. I didn't have the SAP RFC Library files installed on my laptop. (folder nwrfcsdk\lib under SAP). Once I installed them and added the path under SystemPropertiesAdvanced in Windows it worked for me
Can you please specify what exactly needs to be installed? File names and/or SAP Portal search terms are greatly appreciated. The provided information "SAP Netweaver library" or "SAP Client Tools" don't seem to be specific enough for our SAP guys to find what I need. :-(
Thanks for the response! I probably need that information later on, but I am not even there yet. Our SAP guys look into SAP service market place and can't find the needed software to install.
The information i provided was: "Look for something called 'SAP NetWeaver library (32-bit or 64-bit)', 'SAP client tools', SAP Netweaver RFC', or 'SAP Netweaver driver'. The reason they can't find anything could be that the market place, in our case, is in german language. Nevertheless, i think there must be a precise name or ID by which one can find in the portal what is needed.
This was a frustration for us as well....especially since we were using the Preview feature (which used the old LIBRFC32.DLL) before.
I just got this working this morning. 64-bit here.
The item you need to get your SAP BASIS folks to download for you is: SAP NW RFC SDK 7.20 - Patch 40. Get them to search for SAP NW RFC SDK.
They'll need to download the SAR file , and then expand it using SAP's "SAPCAR" utility (basically ZIP, except SAP needed to brand it themselves). The result will be a nwrfcsdk folder which contains the SAP Netweaver RFC SDK.
Put this nwrfcsdk folder into C:\Program Files\sap
Then update your PATH enviroment variable with C:\Program Files\sap\nwrfcsdk\lib
IMPORTANT NOTE: if you are upgrading from the version of PowerBI where SAP BW connectivity was a "preview feature", you'll need to REMOVE the old librfc32.dll from your C:\Windows\system32. Normally, C:\Windows\System32 appears earlier in the PATH, so if you don't remove the DLL, the system will still pick it up before the new version which is at the end of the PATH.