Marcel Westra on 14 Nov 2014 00:30:55
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
Administrator on 25 Mar 2016 06:40:07
SAP BW Connector is available as Preview in March update of Power BI Desktop https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-update-feature-summary/
- Comments (63)
RE: SAP BW
Hi,
As many write, we need to have the key of the field when we connect Power BI to SAP BW, otherwise, it doesn't provide any value add. Is this request in your list and when it will be delivered ? Thank you.
RE: SAP BW
I am on the same boat. I need the KEY of the field in SAP BW BEx query. Without the Key of the field, the SAP BW connector becomes useless for me.
RE: SAP BW
Good day,
We have connected Power BI to SAP BW queries, using the connector. I would like to know how do you display the key of a field and not the text. In BW you have the option of displaying Key, Text or Key and Text.
RE: SAP BW
Success! (Caveat: Worked for me, YMMV.)
The error message is incorrect - you do NOT need librfc32.dll or librfc32u.dll AT ALL.
1) Get Netweaver RFC files for your architecture:
* Search for SAPCAR 7.20 on SAP SWDC
* 32 bit PowerBI: NWRFC_20-20004566.SAR
* 64 bit PowerBI: NWRFC_20-20004568.SAR
2) Extract with SAPCAR
3) Copy all the DLLs in the LIB folder (as of writing, there are 6) to your appropriate folder:
* 32 bit machine: C:\windows\system32
64 bit machine:
C:\windows\system32 if running 64 bit PowerBI,
C:\windows\syswow64 if running 32 bit PowerBI
And then everything worked.
Hope this helps!
RE: SAP BW
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.
RE: SAP BW
Same experience as Sreenivasan. I'm on Win10 64, BW server is on HP-UX IA64.
Frustrating....
RE: SAP BW
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..
RE: SAP BW
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
RE: SAP BW
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.
RE: SAP BW
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..