Multi-tenant HANA database setup

[Anonymous]

Hello community,

I am working with a multi-tenant setup in which one SAP HANA connection parameter string refers to two different databases.

These two databases have the same  

• IP address
• Port
• Instance number

When connecting to this data source in Power BI ("Get data -> SAP HANA database") Power BI does not let me chose between the two underlying databases. Instead, it always connects with the "first" one. 

How can I distinquish between the two databases related to this connection string?

Thanks for your support!

[rbra]

As far as I understand it, every tenant database has its own port to connect to. You can find the correct port by executing the following query in the HANA SYSTEM database - look for the SQL_PORT:

SELECT DATABASE_NAME, SERVICE_NAME, PORT, SQL_PORT, (PORT + 2) HTTP_PORT FROM SYS_DATABASES.M_SERVICES WHERE DATABASE_NAME='<DBNAME>' and ((SERVICE_NAME='indexserver' and COORDINATOR_TYPE= 'MASTER') or (SERVICE_NAME='xsengine'))

Source: https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/LATEST/en-US/440f6efe693d4b82ade2d8b182...

[glenmclaren]

hello, did you manage to connect Power BI to a SAP HANA Tenant ? if so, can you post how you did it, ta, glen

[v-juanli-msft]

Hi @Anonymous 

Are the two databases in different server?

If so, create dynamic parameter when enterinso you can switch between different server names.

Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4

If these two databases are in the same server,

You could write statements in the window "SQL statements" to filter the database you want to connect to.

Here you could create query parameter, then pass parameter in the SQL statements.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.