Exasol connection with multiple tenants

[swaroopkumarmg]

Hi there,

need help with connecting exasol DB to Power bi.

what I have is an Exasol DB with multiple Tenants

Connecting String: same for all tenants

Tenants - more than 3 

Tenant 1 : User id = Tenant1ID, pass: Tenant1pass

Tanant 2: user id = Tenant2ID, pass: tenant2pass

what do I want?

I want to create different Power BI files for each tenants. 

Ex: Teant1 - Tenant1.pbix, tenant 2 - tenatn2.pbix

Problem:

I was able to create tenant1.pbix with tenant1 credentials, the Data source settings we saved under both - Data sources in current file and global permissions,

I then tried to create tenant2.pbix with tenant2 credentials, and by default, it takes tenant1 credentials, so I went into Data Source setting and removed the Exasol entry under Global permissions, thinking that the tenant1.pbix would retain the credentials as it's 'under data source in current file'. and then made a new connection with Tenant 2 credentials. i was able to connect and retrieve data. 

now if I go back to tenant1.pbix it's not connected any more and in the Exasol entry under Datasources in current file for Tenant1.pbix file the credentials are of Tenant2. 

is there a way to get this thing going? please help.

[v-jingzhang · Accepted solution]

Hi @swaroopkumarmg 

All data source credentials used in Power BI Desktop are encrypted and stored in a specific folder in your computer rather than in the pbix files. This is for security concern. That's why we need to reenter the credentials if we copy a pbix file and open it on a new computer. 

When you have the same connection string for multiple tenants in an Exasol DB, it treats the connection string as one single data source. It stores only one credentials for it on your computer. If you edit it in a new pbix file, it will override its credentials with the new one instead of saving both. That's why you found that in Tenant1.pbix file the credentials are of Tenant2.

To deal with that, you'd better prepare different connection strings for different tenants to make Power BI Desktop not take them as the same data source. I have no experience in Exasol so I'm not sure if this is possible. You may seek help about this from Exasol's Community Home - Exasol

Hope this helps. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.