topic Re: Failed to update data source credentials in Service

Failed to update data source credentials

Anonymous — Thu, 02 Aug 2018 15:13:35 GMT

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.

Re: Failed to update data source credentials

v-frfei-msft — Fri, 03 Aug 2018 08:05:11 GMT

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

Re: Failed to update data source credentials

Anonymous — Fri, 03 Aug 2018 13:39:57 GMT

v-frfei-msft Hi Frank, thank you for your response. We are using the Performance edition.

Re: Failed to update data source credentials

v-frfei-msft — Tue, 07 Aug 2018 00:58:11 GMT

Hi Anonymous,

Does my answer make sense? If so, kindly mark it as a solution to close the case. Thanks in advance.

Regards,

Frank

Re: Failed to update data source credentials

joansinho — Wed, 22 Aug 2018 16:45:02 GMT

v-frfei-msft Anonymous

Hi all

I am having the same issue. My company uses Unlimited edition.

Re: Failed to update data source credentials

LeanneShapro — Thu, 23 Aug 2018 20:50:10 GMT

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.

Re: Failed to update data source credentials

Anonymous — Fri, 24 Aug 2018 13:34:11 GMT

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!

Re: Failed to update data source credentials

LeanneShapro — Fri, 24 Aug 2018 14:15:19 GMT

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

Re: Failed to update data source credentials

Anonymous — Fri, 24 Aug 2018 14:25:56 GMT

LeanneShapro no problem! This is the message from their support page:

I'm not sure if this issue would extend to credentials not validating as well, but it may. I have one dashboard currently not updating because of this. When I was having credentials issues, I did create a support ticket and they were very prompt with help until the issue was resolved. Might be worth a shot.

Thanks,

Marc

Re: Failed to update data source credentials

joansinho — Fri, 24 Aug 2018 16:01:33 GMT

LeanneShapro

Hi,

Thank you for the heads up. I am hoping this update resolve my issue. I can't create a ticket without going to ITS at my company because of admits privilege.

Re: Failed to update data source credentials

LeanneShapro — Fri, 24 Aug 2018 16:15:48 GMT

Thanks, Anonymous! I appreciate the help!

Re: Failed to update data source credentials

joansinho — Mon, 27 Aug 2018 17:36:59 GMT

Hi LeanneShapro!

I am wondering if you were able to fix the issue you were having?

Anonymous Thank you for all your updates. They were very helpful.

Re: Failed to update data source credentials

LeanneShapro — Mon, 27 Aug 2018 17:51:41 GMT

Hi joansinho,

Unfortunately we are still looking for a solution. I'll be sure to share on this thread if I do find a resolution.

Re: Failed to update data source credentials

LeanneShapro — Wed, 29 Aug 2018 13:44:27 GMT

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

joansinho

v-frfei-msft

Re: Failed to update data source credentials

Anonymous — Wed, 29 Aug 2018 15:04:43 GMT

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.

Re: Failed to update data source credentials

LeanneShapro — Wed, 29 Aug 2018 15:11:24 GMT

Anonymous Oh wow! That's quite inconvenient! I've got my fingers crossed for us all!

Re: Failed to update data source credentials

joansinho — Wed, 29 Aug 2018 18:07:36 GMT

Hi LeanneShapro Anonymous,

Thank you for the update. I am having the same issue as Anonymous. I have to update all my dashboards on my desktop and then deploy them to the cloud. Now, I am having a table that it's not updating anymore. Hopefully, the update actually happens by the end of the week. Good luck to us!

Re: Failed to update data source credentials

joansinho — Thu, 30 Aug 2018 13:42:54 GMT

Hi LeanneShapro Anonymous,

PowerBI started to work for me today. Hopefully, It starts working for you two. Good luck!

Re: Failed to update data source credentials

Anonymous — Thu, 30 Aug 2018 13:57:18 GMT

joansinho no luck for me yet. An old SF dashboard I forgot to turn the schedule off for sent me an email this morning telling me the refresh failed. Not going to bother turning the schedule back on yet for the others :smileyfrustrated:

Re: Failed to update data source credentials

joansinho — Thu, 30 Aug 2018 14:11:06 GMT

Anonymous

Well, it started to work for me in the sense that it finally took my credentials, and I do not get the message " Failed to update data source credential." I have not checked if they actually refresh. Maybe I will get hundreds of notifications today that my data could not be refreshed :/. Maybe it is too good to be true