Forum Discussion
Cannot change data source credentials to anything different than current credentials because of SSO
Hi Seb_Lz ,
You didn't mention the context - are you in the service, the gateway or the desktop and the type of security settings for SSO that you have implement. However, I did find these documents that might help:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sso-overview
If you are using Kerberos:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sso-kerberos
OR, if you are actually wanting to sign in from the very beginning with the generic userid, you can go here:
https://powerbi.microsoft.com/en-us/landing/signin/ and sign in with that generic userid. Or, on the desktop, sign in in the top right corner with the generic userid.
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Dear collin,
Thanks for your reply. I honestly doubt this issue has anything to do with the Gateway SSO configuration as this is more linked to the way our browsers manage auto-authentication on O365 / PowerBI cloud. I'm simply trying to configure data source credentials on the dataset of my report hosted on app.powerbi.com. I access the powerbi portal using my own O365 (I'm the owner of the report), but I want the report to use another generic account to query the Sharepoint data so that users with no access to the Sharepoint data source can still view the report. Since I'm logged in PowerBI/O365 with my own account, and because of SSO on app.powerbi.com, it seems I cannot actually choose the credentials (whatever account I manually enter will be ignored and replaced by the credentials used to visit app.powerbi.com).
Hi Seb_Lz ,
When you use "Try another account" it doesn't let you change the account? What is the error message? We do this often - where we are signed in but the Data Credentials is different, where we use the generic account. We do this because my userid/password changes but the service account doesn't expire.
Dear collinq
After I click on "use a different account", I get the following 2 screens:step 1step 2
Then it returns to settings page directly, without asking the password, which makes me think it's just using the cached credentials and not the generic account (that account is not cached / saved on my computer). The fact we can only change the data source credentials but not view what the current credentials are is also a bit confusing.
Hi Seb_Lz ,
I agree that is is kind of tough when you can't see the credentials. But, you will get all sorts of errors if the userid that you entered isn't correct. For example, I go this one when I entered the wrong credentials:
But, it goes to this when I got it right:
And, you are right, it doesn't show the current credentials of the id being used.
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!