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

The FabCon + SQLCon recap series starts April 14th at 8am Pacific. If you’re tracking where AI is going inside Fabric, this first session is a can't miss. Register now

SAP BW

A lot of customers are still looking for an easy way to visualize data from SAP BW. SAP is pushing Hana and lumera very hard, with a bw connecter we can push a little bit back
Status: Completed
Comments
mark_chen1
New Member
I was able to connect to SAP BW, but only have access authorization to read partial of cubes/tables. Anyway to make it work to only access authorized data? Thanks.
raffi_sarafian
New Member
Make sure your queries are set to enable access OLE DB for OLAP
rnoone1
New Member
Will there be an option to Connect Live to SAP BW at a future point?
john83
New Member
I was able to make this work and the connection is great if I need a full data set. But many of my cubes require parameters to be entered upon run time and I don't see any way to add in a parameter value or filter. Without this capability, we can't use PowerBI for our primary reports and the SAP BI team wins.
danderson5
New Member
Followed Vinay SCN doc as shown in lower post on Win8.1 device (copied librfc32.dll from /windows/sysWOW64 to /windows/system32 is the only place where I deviated from script) Details: "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)."
axdanie
New Member
I am getting the below error. Can anyone help in solving the issue: Details: "SAP Business Warehouse: Error while receiving function return values: FU_NOT_FOUND
rajeshk2i2398
New Member
Meanwhile SAP promoting the same future as Power BI in SAP Cloud for Analytics Which is similar User Interface as Power BI and it is tightly connect to SAP BW and SAP BPC. May those who looking for hassle free integration with sap and supporting the Variables , Parameters and hierarchies , Etc..
sree2005nv
New Member
For 64 bit , Im getting the below message. I believe most the users are experiencing the same. Details: "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)." i got the DLL file downloaded and put in syntem32 folder.. still same issue. do you know how to fix this..
micheleconz
New Member
Same experience as Sreenivasan. I'm on Win10 64, BW server is on HP-UX IA64. Frustrating....
shreyas_ketkar
New Member
I am trying to connect to SAP Business Warehouse database and getting the same error. Details: "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)." Is there a solution to this? Please advise.