Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
PS. I did have datasets with the same server-db with different credentials for a while, and It worked fine. It seems as though this is a change that occurred recently.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.