connecting SAP Hana or BW to PowerBI

My company uses SAP however nobody really knows how to use it. I do business intelligence for them and need to connect PowerBI to the SAP environment to run reports. one consultant is telling me to connect to the SAP business Warehouse, I can connect but I can not see any data in the tables. We run SAP hana4 cloud... I can not get connected to the Hana database and the ODBC connector I installed fails with error messages. i really need someone that know how to connect PowerBI to SAP