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.