Forum Discussion
SalesForce scheduled synch setup returns error
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/.)
45 Replies
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/.)Same exact problem here. did anyone was able to get a work around this?
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??
Manual refresh fails - credentials work on Power BI Desktop but not PowerBI.com
Also I can no longer access the SalesForce content Pack
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étailsID 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/.) have you solved this issue??
pauliusmaciulis Manu31majdkaid22ChrisB HAve anyone solve this?
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:13ZI'm definitely not canceling anything.
Same error here, too. Please find a solution!
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
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
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
faisalmo thanks mate. am on the latest version and my SalesForce is Enterprise Edition. still having the same problem for 3 months now..
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**
I've just responded to the support desk with another set of screenshots so will keep you posted on the response
Below is the latest respond I've got on my ticket
Hi Majd,
The latest information that I had received from our product group on this issue is that they believe it is something to do with your SalesForce accounts. They are looking deeper into this and I do apologize for the inconvenience of how long this is taking for us to get this resolved.
My query is still being investigated
I've provide them screenshots of my Salesforce oAuth connected apps to check that this is not part of the issue
I had the same problem for the past 4 months. The solution I found is to disable one of SaleForces security setting under the Health Check for Security Controls called “Force relogin after Login-AS-User”.
James Cheng
