How to make report from live data from SAP ECC in PBI

[Anonymous]

Hello, Everyone.

I have very little knowledge about PBI.

I requested access to the SAP database to make real-time reports in PBI.

they have provided me server address as

Users have been created in BCD (DEV BW). Kindly refer to the connection details when getting data from the application server ABAP.

I can log in using the username and password.

I want to ask if is it the same database where our SAP running or somethings else.

Please guide me how can i fetch dat.

Regards

Asif

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

There is no direct connection from Power BI to SAP ECC.

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. 

refer:

https://community.powerbi.com/t5/Power-Query/How-get-data-directly-from-SAP-ECC/td-p/411305 

Best Regards

Lucien