Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

How get data directly from SAP ECC

Since the last question someone asked about that was 2 years ago. I wanna know if its possible to get data direclty from the SAP. I am pretty sure that my SAP is ECC, and I wanna know how I can pull...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you very much for your reply. I understood the steps you have specified is from Power BI side. I would like to how to establish the connectivity between SAP and Power BI. Is there any gateway configuration that needs to be done from netweaver side. Also we have tried to create the project via SEGW  and initiated the config however we are confused from connectivity point of view. Could you please let me know the steps that needs to be done from SAP ECC side.

 

Thank you.

 

Regards

Raj

Anonymous's avatar
Anonymous
Not applicable
7 years ago

There is no direct connection from Power BI to SAP ECC. And I would assume there never will be. 

 

Your options are but not limited to (As others may have come up with other ways to get data):

  1. Direct connection to the database
  2. Connect to SAP BW (Which can be done through Power BI)
  3. Connect to SAP Hana (Which can be done through Power BI)
  4. Follow the examples from sreenathv and use the DBCO T-Code or SAP PI and put your data in a different database and then once again use a direct connection to the database that has your replicated data. 

I've have talked to other companyies who do schedule nighly reports to be ran and saved to a network drive. They then consume these reports in Power BI with the Excel connection.