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.