We are planning to use Power BI as a self service reporting tool and planning to access data from our HANA and BW on HANA databases either by directly querying the tables or by querying calculation views. i read in some articles that we can do that by connecting to HANA DB from Power BI by providing uid,pwd and DB host,instance and port number.and looks like it will open an ODBC connection.
Can someone please let me know SAPs thoughts on this whole approach.? will there be any security concerns ? our security team is reluctant to allow the same port for Power BI , i am not sure if that can be done using a different port.