topic Re: SalesForce scheduled synch setup returns error in Power Query

SalesForce scheduled synch setup returns error

pauliusmaciulis — Fri, 16 Oct 2015 22:26:38 GMT

I work with the PowerBI Desktop version and dashboards are published to the web. The SalesForce login works from the PowerBI Desktop version and I can get the reports data from SalesForce. But when the pbix file is published I am unable to update data source credentails for the SalesForce data source in order to setup scheduled SalesForce data synch. Any help would be appriaciated!

I see the following error message:

The credentials you provided for the data source are invalid. Please ensure the credentials you have provided for all the data sources are valid.

Hide details Activity Id:7a1f96f4-5927-4543-bf99-d383e99977aa

Request Id:tracheae

Status Code:400

Time:Fri Oct 16 2015 17:17:02 GMT-0500 (Central Summer Time)

Version:11.0.9168.320

Cluster US:helps://centraler.analysis.windows.net

Details:The credentials provided for the Salesforce source are invalid. (Source at helps://log.salesforce.com/.)

Re: SalesForce scheduled synch setup returns error

ChrisB — Wed, 25 Nov 2015 16:10:44 GMT

I am having exacty the same problem - the Salesforce credentials are good, but PowerBI refresh compains they are invalid with eeither Error 200 or Error 400

I have also checked in Salesforce Login history and it reports that POwerBI refresh has sucessfully logged in.

------------------------------------------------------

Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again. Hide details
Activity ID: 8770a3ce-72eb-c9a0-ad4d-7a9b518f1248
Request ID: 9e4f7f26-dadc-6c69-b481-5ae5081225f7
Status code: 200
Time: Wed Nov 25 2015 15:48:14 GMT+0000 (GMT Standard Time)
Version: 11.0.9168.864

-----------------------------------------------------------

Failed to update data source credentials: The credentials you provided for the data source are invalid. Please check the credentials for all the data sources.

Hide details
Activity ID: 8770a3ce-72eb-c9a0-ad4d-7a9b518f1248
Request ID: c7226711-7247-c8e9-dede-6a5cf04981cd
Status code: 400
Time: Wed Nov 25 2015 15:59:02 GMT+0000 (GMT Standard Time)
Version: 11.0.9168.864
Cluster URI: https://wabi-us-north-central-redirect.analysis.windows.net
Details: The credentials provided for the Salesforce source are invalid. (Source at https://login.salesforce.com/.)

Re: SalesForce scheduled synch setup returns error

majdkaid22 — Wed, 10 Feb 2016 07:18:24 GMT

Same exact problem here. did anyone was able to get a work around this?

Re: SalesForce scheduled synch setup returns error

Manu31 — Mon, 15 Feb 2016 12:56:21 GMT

Hi there, here i have the same issue..

Échec de la mise à jour des informations d'identification de la source de données : Les informations d'identification que vous avez fournies pour la source de données ne sont pas valides. Vérifiez les informations d'identification pour toutes les sources de données.

Masquer les détails

ID d'activité:	9513b6d1-2d2e-4dcc-0c43-fb9cf054ca0d
ID de demande:	71668b0f-56f5-3051-04af-9c830ba1cfae
Code d'état:	400
Heure:	Mon Feb 15 2016 13:48:58 GMT+0100 (Paris, Madrid)
Version:	13.0.800.434
URI du cluster:	https://wabi-north-europe-redirect.analysis.windows.net
Détails:	The credentials provided for the Salesforce source are invalid. (Source at https://eu2.salesforce.com/.)

Re: SalesForce scheduled synch setup returns error

oristides — Fri, 11 Mar 2016 20:35:31 GMT

same problem!! I created my report on desktop and even i can refresh mannyally there..

then I publish to powerBI and i got this Error 400.. What should we do friends??

Re: SalesForce scheduled synch setup returns error

oristides — Fri, 11 Mar 2016 20:36:40 GMT

have you solved this issue??

Re: SalesForce scheduled synch setup returns error

oristides — Mon, 14 Mar 2016 18:47:08 GMT

pauliusmaciulis Manu31majdkaid22ChrisB HAve anyone solve this?

Re: SalesForce scheduled synch setup returns error

lstreed — Tue, 22 Mar 2016 17:13:54 GMT

I am having the same issue, but in addition to the credentials error, I'm frequently getting this one:

Hide Scheduled 3/21/2016, 4:41:05 PM 3/21/2016, 4:45:13 PM Failed An error occurred while processing the data in the dataset.
Data source type:
Processing error: The operation is canceled by user.
Cluster URI: WABI-WEST-US-redirect.analysis.windows.net
Activity ID: 90f86615-5d75-4967-96e9-71996b8a7802
Request ID: e61ee45e-e259-4e02-b898-3493e1b12c84
Time: 2016-03-21 23:45:13Z

I'm definitely not canceling anything.

Re: SalesForce scheduled synch setup returns error

cmcreynolds — Tue, 05 Apr 2016 14:15:06 GMT

Same error here, too. Please find a solution!

Re: SalesForce scheduled synch setup returns error

majdkaid22 — Tue, 05 Apr 2016 17:32:32 GMT

I'm having this issue for a month now. I opened a ticket with Power BI support and been on back and forth e-mails.

No solution as of you and it's so frustrating. will keep you posted

Re: SalesForce scheduled synch setup returns error

oristides — Wed, 13 Apr 2016 17:48:38 GMT

Hello Friends!!

I got it

The problem is because your Salesfroce edition. I used to have salesfroce professional editions but you must have an edition thats allows API integrations, like Enterprise edition. Now I upgraded to Salesfroce enterprise edition(expensiver edition) and as you can se and theres is no X saying something about credentials.

i got nuts with this but finnally I solved. Now

Re: SalesForce scheduled synch setup returns error

faisalmo — Thu, 14 Apr 2016 15:44:58 GMT

This should not have anything to do with the edition of Salesforce you are using.

I'd suggest that everyone experiencing this issue move to the latest version of the Power BI Deskop. There was a fix last month that had to do with salesforce connectivity. Let us know if you are still experiencing issues after downloading the latest Desktop release.

https://powerbi.microsoft.com/en-us/desktop/

Faisal Mohamood

Re: SalesForce scheduled synch setup returns error

c_tewalt — Mon, 02 May 2016 16:40:13 GMT

I am still experiencing issues trying to schedule refresh on PowerBI.com for Salesforce data. The error states my credentials are invalid, however I have successfully logged in through IE and also on Power BI Desktop. I also have the most recent April 2016 Power BI update.

Any assistance would be appreciated.

Thanks!

Re: SalesForce scheduled synch setup returns error

wynhopkins — Thu, 05 May 2016 01:37:33 GMT

Manual refresh fails - credentials work on Power BI Desktop but not PowerBI.com

Also I can no longer access the SalesForce content Pack

Re: SalesForce scheduled synch setup returns error

majdkaid22 — Wed, 11 May 2016 08:24:13 GMT

pauliusmaciulis wynhopkins c_tewalt faisalmo oristides

Guys, have any of you been lucky solving this issue?

am personally still stuck with powre BI team trying to figure out the problem. Been 2 months exactly!!

Re: SalesForce scheduled synch setup returns error

majdkaid22 — Wed, 11 May 2016 08:30:44 GMT

faisalmo thanks mate. am on the latest version and my SalesForce is Enterprise Edition. still having the same problem for 3 months now..

Re: SalesForce scheduled synch setup returns error

wynhopkins — Wed, 11 May 2016 12:09:16 GMT

majdkaid22 I'm in the Support Queue - was last contacted on 7th May

Re: SalesForce scheduled synch setup returns error

majdkaid22 — Thu, 12 May 2016 05:39:41 GMT

wynhopkins thanks for the heads up. Same here, been quite some time now..

Re: SalesForce scheduled synch setup returns error

c_tewalt — Tue, 17 May 2016 14:45:37 GMT

majdkaid22

I have not had any luck in getting this resolved either.

Re: SalesForce scheduled synch setup returns error

dmoffat — Tue, 17 May 2016 15:30:07 GMT

3 Months !!!!!

How is this possible ? If this WAS working and in production and this failure goes on for 3 months what does Microsoft say about that ? ! That is toally unacceptable to me.

This combined with the refresh issues I am having woth Excel files makes me seriously question whether we all should be using this tech until they get it working. Makes us all look like fools to have to explain this kind of thing to our clients/bosses. They just won't understand and shouldn't have to ..

**bleep**