Forum Discussion
How get data directly from SAP ECC
1. Launch Power BI
2. Select 'Get Ddata'
3. Select the Database Source that your instance of ECC is on. In my case its a SQL Server Database
4. Enter the Server Name that the database is on
5. Enter the Database Name
6. (I do it this way) Expand 'Advanced Options' and paste your SQL Statement
7. Click Ok and your done. Here is the output from my select statement.
As mentioned in previous posts this requires you to have a full use database license. There are instances where the database that SAP runs on is a runtime license which means that the application is the only one that can access the database. This is licensing issue more than a technical issue. If you have a runtime license you can still technically do the above but from a licensing standpoint you'll most likely run into issues with SAP.
Also, you'll need your DBA or who ever manages your databases to create a Read-Only databse user that you can use to login with. I don't know what else to add, your simply connecting to a database just like any other database.
Please note that we do have a Full-Use SQL Server Database License.
Hope that helps.
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
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):
- Direct connection to the database
- Connect to SAP BW (Which can be done through Power BI)
- Connect to SAP Hana (Which can be done through Power BI)
- 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.
I appoligize but I didn't know what SEGW was. If you are exposing your data through odata services then you can point Power BI at the odata. I assume you have tested in a browser that you can connect to your odata connection that you've configured with SAP??
With in Power BI there is an OData Connector, you should just need to enter your url for the odata feed.
Then within the Power BI Service you would configure an odata connection in the gateway. You just need to supply the url and credentials.
Thanks for your reply. Please find the below queries from my side.
1) you are just simply saying after the service created within the SAP and tested it via browser. OK coming to your point how this service built in SAP ECC going to connect to Power BI. If we built the connectivity then there should be the soure and target systems should have the connectivty method. Which method we need to use to estabish the connectvity between SAP and Power BI .? So how SAP ECC is going to connect with the Power BI.?