Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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?
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
29 | |
12 | |
12 | |
11 | |
8 |
User | Count |
---|---|
54 | |
27 | |
15 | |
14 | |
13 |