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

 

 

 

 

 

1 REPLY 1
Highlighted
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
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.

Helpful resources

Announcements
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.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

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

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 60 members 1,383 guests
Please welcome our newest community members: