Follow these steps to connect to data source from sap hana:
1. Go to New Data source.
2. Type your server name, the port name is by default.
3. Select mode of authentication (window /database).
4. Type any sql statements. (optional)
5. Download connector from, https://support.sap.com/en/product/connectors.html and install.
6. Then Click on sign in.
8. Select required tables and fields residing in hana for creating your report and visualization.
9. Go to sheet.
Hope this help you.