Skip to main content

Power BI

Completed

SAP BW

Vote (206) Share
Marcel Westra's profile image

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)
Marcel Westra's profile image Profile Picture

Power BI User on 05 Jul 2020 22:20:03

RE: SAP BW

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)."

Marcel Westra's profile image Profile Picture

Rory on 05 Jul 2020 22:19:58

RE: SAP BW

Will there be an option to Connect Live to SAP BW at a future point?

Marcel Westra's profile image Profile Picture

Raffi Sarafian on 05 Jul 2020 22:19:01

RE: SAP BW

Make sure your queries are set to enable access OLE DB for OLAP

Marcel Westra's profile image Profile Picture

Power BI User on 05 Jul 2020 22:19:00

RE: SAP BW

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.

Marcel Westra's profile image Profile Picture

Power BI User on 05 Jul 2020 22:18:44

RE: SAP BW

Ensure the SAP BW System is Unicode . Since for the FU_NOT_FOUND is something related with the Unicode system

Marcel Westra's profile image Profile Picture

Power BI User on 05 Jul 2020 22:18:44

RE: SAP BW

32bit works for me. 64bit not, with error librfc32.dll. I can only cubes and DSO but not Queries.

Marcel Westra's profile image Profile Picture

Ruben Dominguez on 05 Jul 2020 22:18:28

RE: SAP BW

Can´t make it work.In the 32 bit version I get this:

Details:"SAP Business Warehouse: An error ocured when contacting the service:Error While receiving function return values: FU_NOT_FOUND"

For 64 bit , I'm get this.

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)."

Marcel Westra's profile image Profile Picture

chris golding on 05 Jul 2020 22:18:27

RE: SAP BW

I'm still having issues getting the 64 bit version working (as per error messages posted by other people). The 32 bit version worked fine with no issues. Are there different steps for the 64 bit setup?

Marcel Westra's profile image Profile Picture

Vnay on 05 Jul 2020 22:18:24

RE: SAP BW

Thanks to the Power BI team for releasing this crucial feature that will surely enable Enterprise wide Dash-boarding possible.
Please follow the below link for a step-by-step guide on connecting to SAP BW Data Warehouse from Power BI Desktop.

http://scn.sap.com/docs/DOC-71568

Would request Power BI team to please have a look at the " Issues yet to be resolved" section of this document and provide the solution( Single Sign-on) to make this feature complete and widely adopted in Enterprises which have Single Sign-on as a policy.

Thanks
Vinay
Hope this helps .

Marcel Westra's profile image Profile Picture

Power BI User on 05 Jul 2020 22:18:23

RE: SAP BW

Getting the same errors when I try. Please post a solution if you find one!