Power BI and SAP – What Works and What Doesn’t

3 comments

I run many workshops focused on integration of Microsoft Analytics and SAP. This is not an easy topic to cover due to complexities of the SAP landscape and also because Microsoft Analytics has many moving parts both with respect to its on premise and cloud components. In this article, I will just focus on Power BI and SAP ECC, Hana and BW.

Functionality

ECC

Hana

BW

Power BI Connector Available

NO

YES

YES

Direct Query Support

NO

YES

NO

ODBC Support

N/a

YES

N/a

Hana Information Models Support

N/a

YES

N/a

SSO (Kerberos)

N/a

NO*

NO*

SSO (SAML)

N/a

NO

NO

Message/Load balancer

N/a

N/a

NO*

Query Parameters

N/a

YES

YES

Infocube support

N/a

N/a

YES

BEx support

N/a

N/a

YES

* – the word on the street is that these NOs are expected to become YES soon

The following is a list of random points that are good to know as you implement a Power BI solution against SAP, in no particular order:

  1. Microsoft covered BW connectivity pretty well here, however, I just want to point out that in order to install the BW client you need to copy the client DLL files into the System32 folder OR you can find the installation folder for the Power BI Desktop (in my case it’s in C:\Program Files\Microsoft Power BI Desktop\bin) and copy the DLL files there
  2. You can connect to Hana using the ODBC connector or the SAP Hana connector, but be aware that the ODBC connector only supports import based models (no direct query support right now). When you use the SAP Hana Connector, it assumes that you are trying to connect to Calculated or Analytic views, so no tables are exposed in the interface by default. You need to write a SQL Select statement to connect to tables (row or column) but you will be able to connect in a direct query mode
  3. The Hana connector does not work well with semi-additive measures
  4. Query parameter support can be finicky, the simpler the query the better
  5. Getting Key Values from BW is possible but not very intuitive, follow this post for details
  6. Business Object universes are Not supported (from what I have heard, killed by SAP)
  7. Power BI connects to SAP S4 HANA and BW interfaces
  8. Many customers are asking about the Direct Query support for BW but I keep wondering why…. The performance of most BW systems is so poor that I would almost never consider opening them up for Direct Query

The SAPPHIRE 2017 is just around the corner; I am looking forward to additional roadmap information becoming available around that time.

3 comments on “Power BI and SAP – What Works and What Doesn’t”

  1. Hi,
    Thank you for sharing the overview between SAP ECC, Hana and BW.

    I’m working on SAP ECC and have been considering using Power BI instead of implementing QlikSense. Is there any workaround to make Power BI work with SAP ECC?

    Does it make it any easier if “direct query” is not required in this case? I’m thinking a daily data refresh from SAP ECC to Power BI would be sufficient.

    Would be glad to hear from you, appreciate your help. Thank you.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s