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
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!
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.
Community Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.