Forum Discussion
Refresh Fails after Updating Active Directory password - Credentials Invalid
I have had this dataset refreshing every day without issue for a long time; today I had to update my Active Directory password, at which point refreshes started failing. I assumed this was due to the SharePoint files used in the datasets, and I was able to successfully reauthorize those connections, only to find that the refresh would still fail. Now I see the problem lies with the SQL query, which works fine using Windows authentication on my desktop PBI, and in the Gateway settings it is configured to use the admin account Windows credentials, so it tells me that I do not need to enter my credentials for this source... now I'm stuck with a situation where it's telling me I do not need to enter my credentials for the SQL query (and doesn't give me a way to do so), but at the same time it is telling me my credentials are invalid:
- Anonymous6 years ago
Figured it out, my AD credentials were also what the gateway was using... needed to update password on the gateway settings, and now it works.
1 Reply
- AnonymousNot applicable
Figured it out, my AD credentials were also what the gateway was using... needed to update password on the gateway settings, and now it works.