These are the 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
6. Then Click on sign in.
8. We need to Select required tables and fields residing in hana for creating your report and visualization.
9. Go to sheet.
Hope this help you.