Possibility connect Power BI to SAP ECC

[Ahmedw]

Dear all,

I am trying to connect Power BI Desktop with (SAP ECC 6 EHP 4 (DEV) system) to pull data from SAP ECC system to Power BI, but below error came:

___________________________________________________________

DataSource.Error: The SAP BW server reported an error: 'Unknown error when executing MDX'. To find more information about this error, visit the SAP support site and search for 'BRAINOLAPAPI 012'.

Details:

    DataSourceKind=SapBusinessWarehouse

    DataSourcePath=192.5.2.8/05/400

    ID=BRAINOLAPAPI

    NUMBER=012

    SYSTEM=DEVCLNT400

    Command=SELECT

    {

        [Measures].[0PPM_QNT]

    }ON 0

FROM [$0PPM_VC1] CELL PROPERTIES VALUE

______________________________________________________

Question,

1- Can make direct connection between SAP ECC (DEV) and Power BI?

if Yes, please guide my how connect.

For your information,

- Our SAP is ECC 6 EHP 4 

-I have tried connect Power BI with SAP ECC (BI) and it was working well.

[dexterz]

power bi can connect sap hana,sap bw. for ecc maybe you can use sap odata feed

[Anonymous · Accepted solution]

See this post which discusses the same: 

https://community.powerbi.com/t5/Integrations-with-Files-and/How-get-data-directly-from-SAP-ECC/td-p...

To answer you question, yes you can connect directly to SAP ECC but you'll connect at the database layer and not through the applicaion. 

What database sits under SAP ECC? 

Do you have a Full Database License or a Runtime License? If you have a full use then you can access the database and read data from the tables using a SQL Server or Oracle Connection. 

[Ahmedw]

Our SAP Database is DB2

[v-yulgu-msft]

Hi @Ahmedw,

Please try to connect to underlying database to fetch data as lmf232s suggested.

Regards,

Yuliana Gu

[gudakrishna]

Hi,

1) which driver need to bel install to connect SAP ECC through Power BI?

2) what are the possibility ways to connect SAP ECC ?

Thanks in Advance.

Best Regards

Venkata Krishna

[Anonymous]

Let's put it this way, you're not connecting directly to SAP ECC but rather directly connecting to the database that sits under SAP ECC. There is no connection avaialble that will allow you to access SAP ECC through the app layer (That Im aware of). As such, you'll need to access the data/tables from the database directly.  So if SAP ECC has a SQL Server databse then use the SQL Server connector, if its Oracle then use the Oracle connector, etc. 

Note that unless you already have access to the database you'll need to talk to your DBA to get a DB Account created (READ ONLY!!) and then you can use that to access the database directly. 

This is an image of the SQL Connector for Power BI and what you have to enter. 

[v-yulgu-msft]

Hi @Ahmedw,

Based on my research, currently it is not available to directly connect to SAP ECC from Power BI. An idea has been submitted in this link, please vote it up.

Regards,

Yuliana Gu