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?
@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".
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
19 | |
18 | |
18 | |
9 |