Forum Discussion
Failed to update data source credentials
I come in this morning and for some reason every dashboard I have that has Salesforce as a data source is unable to refresh online. I get this error:
I'm able to login to Salesforce itself, can refresh manually from Power BI Desktop, but my scheduled refreshes are having an issue on my workspaces. Has anyone else experienced this before? This has been working properly everyday for months until today. I have not changed or updated any credentials recently from Salesforce.
Hi LeanneShapro,
This could be 2 different things:
1. Microsoft recently acknolwdged it's been having issues with Salesforce refreshing. They're currently looking into the problem. This is just a refreshing error though, so it might not be the cause here.2. I did end up fixing the issue in my case by creating a new password from Salesforce. For some reason, I had 3-4 days before my password expired from Salesforce, but PBI was already telling me my credentials were invalid. This was only happening from the service, I could refresh fine from the desktop file. So on the day when my password officially expired and I had to create a new one, the report started working again from the service and I was able to successfully login.
Even more strange, I've had to reset my password before from Salesforce since we have to every 3 months. This was the only time I've ever had the issue.
I hope this helps!
26 Replies
I have a Microsoft Support Case open currently and mentioned the Salesforce related issues I'm having. He said the following, "
There is currently a known issue about attempting to refresh Salesforce reports. It’s also having some side effects of being able to update the credentials."
He also sent a link for their support page which says, "Users of Salesforce reports may experience issues with refreshing reports. Engineers are working to deploy a fix. We are expecting the deployment to complete by end-of-week. Next update @ 8/29/18 at 10:00 PDT"
Anonymous
Thanks LeanneShapro for that! I have 3 dashboards using Salesforce that aren't updating from the service so I have to do it from the desktop then publish to the service. It's really inconvenient :smileysad: I do so much digging into my own data only to find out the issue isn't anything that I've done. I rely on daily refreshes so it's all frustrating. I've been manually refreshing all 3 dashboards twice a day and publishing each of them to 2 different workspaces. Microsoft was having this exact issue just earlier this month.
Anonymous Oh wow! That's quite inconvenient! I've got my fingers crossed for us all!
Hi Anonymous,
Can you please check if you are using one of the supported editions for API access. Please see below.
https://help.salesforce.com/articleView?id=000005140&type=1
Editions with API Access
To use the API, your organization must be on one of the following 4 editions (the API is enabled by default):
- Enterprise Edition
- Unlimited Edition
- Developer Edition
- Performance Edition
Editions with no API Access- Contact Edition
- Group Edition
- Professional Edition
Regards,
Frank
v-frfei-msft Hi Frank, thank you for your response. We are using the Performance edition.
Hi Anonymous,
Does my answer make sense? If so, kindly mark it as a solution to close the case. Thanks in advance.
Regards,
Frank
Anonymous I am experiencing the same issue and can't seem to find any documentation online. I have an error message that says "Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again." When I click Edit Credentials, I login with my SFDC credentials, and then it spins for a minute. Then I get the timeout error like you've pictured below.
Hi LeanneShapro,
This could be 2 different things:
1. Microsoft recently acknolwdged it's been having issues with Salesforce refreshing. They're currently looking into the problem. This is just a refreshing error though, so it might not be the cause here.2. I did end up fixing the issue in my case by creating a new password from Salesforce. For some reason, I had 3-4 days before my password expired from Salesforce, but PBI was already telling me my credentials were invalid. This was only happening from the service, I could refresh fine from the desktop file. So on the day when my password officially expired and I had to create a new one, the report started working again from the service and I was able to successfully login.
Even more strange, I've had to reset my password before from Salesforce since we have to every 3 months. This was the only time I've ever had the issue.
I hope this helps!
Hi Anonymous,
I appreciate your response. I reset my Salesforce Password this morning and it didn't seem to resolve the issue. I'll do more research and see if it could be related to Salesforce refreshing.
If I find a solution, I'll be sure to share it here!
My best,
Leanne
