Based on this old thread :
1. SAP HANA connector (I have not tried the connector)
2. SAP BW connector via Power BI Desktop. I am assuming if you have SAP ECC, then there will be equivalent SAP BW cubes. You will need your SAP/IT area to provide you with the relevant credentials). My company has been using this method.
3. Ask IT to build a custom API that will work (ie. JSON with OAUTH2 security) - probably the best long term method, but will be difficult to convince IT.
The challenges you face will be getting SAP Admin OR IT to allow Power BI to connect to SAP ECC. Security will always be the number 1 reason they use. With the right governance and implementation, it won't be an issue.
Proud to be a Power BI Super User !
Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
