cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
swaroopkumarmg
Helper II
Helper II

Exasol connection with multiple tenants

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.

 

 

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

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.

View solution in original post

1 REPLY 1
v-jingzhang
Community Support
Community Support

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.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors