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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.