Showing results for 
Search instead for 
Did you mean: 
dlvhpfs Occasional Visitor
Occasional 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

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 307 members 3,188 guests
Please welcome our newest community members: