Datasource not unique per dataset

[TBardien]

It seems as though each datasource for the same server-db combo cannot be unique to a dataset.

I have 2 different reports, 2 different datasets, pointing to the same server-db, with different credentials. It seems as though this is not possible.

So my problem is as follows:

Report A with dataset A with Datasource for server x and db y.

Report B with dataset B with Datasource for server x and db y.

When I change the credentials for the Datasource for dataset A to user "user1" and "password1", the credentials for dataset B's datasource seem to make the same change.

Does anyone have any insight into this? Is this not possible?

[Greg_Deckler]

@TBardien - I believe you are correct on this. The reason is that Power BI stores a data connection entity under the hood that stores the credentials. I would recommend using a DNS alias or IP address for your second connection. Power BI should see that as a separate connection.

[TBardien]

@Greg_Deckler 

Was this changed recently. Because It does not seem it did this before.

I had 2 reports with 2 different datasets with identical server and db, and could use different credentials for the datasources of the 2 datasets effectively.

This problem seems to have been introduced recently.

[Greg_Deckler]

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".