Exasol connection with multiple tenants

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.