I have 2 reports in the workspace published by the same person with below configuration -
Data Source - xyz.salesforce.com (a instance)
Username - a123
Data Source - xyz.salesforce.com (b instance)
Username - b123
Once b.pbix is published, it overwrites the credentials of first report - a.pbix which connects to a different instance using the same URL.
After doing some research, I found this note within documentation -
Each user can only have one set of credentials per data source, across all of the data sets they own...
Not sure why is this an expected behaviour. Apart from Salesforce, there are other cloud platforms which provides single URL to different instances based on user login.
Please help to overcome this issue.
Here is a similar idea. You may leave a comment and vote it up to help improve Power BI.