Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
chrissim16
Frequent Visitor

Unable to get SAP BW Connector Preview working

Hi Everyone,

 

We are trying to evaluate Power BI for our SAP BW reporting purposes. The newest version of PowerBI Desktop has the new BW connector as a preview which would allow direct connection to the BW cubes. However, we are unable to get the connection up as we get the following message:

 

"SAP Business Warehouse: An error occured when contacting the service: Cannot call classic RFC API. See help for details.
Please put a recent 64-bit version of librfc32.dll in your System32 folder (typically C:\Windows\System32).
See SAP note 413708. Please make sure you have installed Visual C++ 2005 SP1 ATL Security Update (x64)"

 

We followed the steps that were suggested in this document  (SAP KB) :

1. Before going further in this document please make sure that you have downloaded and installed the most recent version of Microsoft Power BI Desktop tool from Here (Version: 2.33.4337.281 64-bit (March, 2016)   )

2.Make Sure to activate the new preview feature by navigating to Menu--> Options --> Preview Features  and checking the SAP BusinessWarehouse Connector option as shown below.

3. Download the most Recent version of librfc32.dll 64-bit version from Support Packages and Patches | SAP Support Portal , take your Basis Admin's help.Place the file in your systems C:\Windows\System32 location .

4.  Download the latest Microsoft Visual C++ 2005 Service Pack 1 from here

5. Make sure that Your Basis Administrator has disabled the Single Sign On option for your user account and enabled the Logon using Username/Password option.

 

but we still getting the same error message. Are there any other prerequisites that we should know of? Has anyone been able to successfully connect to their BW environment?

3 REPLIES 3
chrissim16
Frequent Visitor

I was able to get it to work for the 32-bit version, no such luck yet for the 64-bit

How did you make it to work with 32 bit version , are you able to pull the data from BW ? 

Using 32-bit Power Bi Desktop I didn't need to install any component to connect to BW, but I'm having problems with more than 100.000 records.

 

Have you tried https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sap-bw-connector/ ???

 

I couldn´t find the 6.40 RFCSDK for Windows (32-bit application) on SAP Support Portal.

 

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors