Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
@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.
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.
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".