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

SAP BW Connector not working with new Desktop version 2.37.4464.361 64-bit (July 2016)

Hi all,

I just installed the new Power BI Desktop version 2.37.4464.361 and the SAP BW Connector is giving error

2016-08-04 12_28_39-FW_ Power BI - Message (HTML).png

All Netweaver library are present and If I go back to the prior version 2.36 everything works.

Did anybody experience the same issue?

Thanks-

13 REPLIES 13
jonsnowboard Frequent Visitor
Frequent Visitor

Re: SAP BW Connector not working with new Desktop version 2.37.4464.361 64-bit (July 2016)

I have the same issue. I have tried with 32 and 64 bit versions of Power BI desktop with no success. I am going back to the previous version of the desktop tool for now.

tristanstcyr Regular Visitor
Regular Visitor

Re: SAP BW Connector not working with new Desktop version 2.37.4464.361 64-bit (July 2016)

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?

 

Thanks,

Tristan

fmazzoleni Frequent Visitor
Frequent Visitor

Re: SAP BW Connector not working with new Desktop version 2.37.4464.361 64-bit (July 2016)

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

Sokon Member
Member

Re: SAP BW Connector not working with new Desktop version 2.37.4464.361 64-bit (July 2016)

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. :-(

fmazzoleni Frequent Visitor
Frequent Visitor

Re: SAP BW Connector not working with new Desktop version 2.37.4464.361 64-bit (July 2016)

Here is the folder and the file I installed:

2016-08-12 17_16_14-lib.jpg

 

Then into cmd.exe  SystemPropertiesAdvanced-->Advanced-->Enviroment Variables I added the lib path into the Path session.

Hope this helps

Sokon Member
Member

Re: SAP BW Connector not working with new Desktop version 2.37.4464.361 64-bit (July 2016)

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.

corey_hallisey Frequent Visitor
Frequent Visitor

Re: SAP BW Connector not working with new Desktop version 2.37.4464.361 64-bit (July 2016)

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.

 

Hope this is helpful.

Highlighted
corey_hallisey Frequent Visitor
Frequent Visitor

Re: SAP BW Connector not working with new Desktop version 2.37.4464.361 64-bit (July 2016)

One other thing we ran into connecting to BW:

- we couldn't connect to our BW instance via SAP Gateway.  We had to directly connect to one of the BW servers in our landscape specifically.

 

Re: SAP BW Connector not working with new Desktop version 2.39.4526.362 32-bit (September 2016)

Hi Folks,

 

I am using SAP Net Weaver 7.3 and BW client tools and I installed Power Bi Desktop version 2.39.4526.362 32-bit (September 2016).

NOTE: I installed previously Power BI Desktop July version but without using much or testing the BW connectivity.

 

Then I followed this thread, downloaded & installed NW RFC_60-20000067.SAR & applied all the notes presented in this topic.

 

Still, I cannot connect to SAP BW from Power BI Desktop. Here is the error message:

 Power_Bi_Desktop_Sep.16_edition-BW_Connector-Error.jpg

 

 

Any pieces of advise left ?

 

Dragos

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.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 269 members 3,032 guests
Please welcome our newest community members: