Showing results for 
Search instead for 
Did you mean: 
dlvhpfs Visitor

Multi-tenant HANA database setup

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!






Community Support Team
Community Support Team

Re: Multi-tenant HANA database setup

Hi @dlvhpfs 

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


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.

Helpful resources

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 154 members 1,826 guests
Please welcome our newest community members: