cancel
Showing results for 
Search instead for 
Did you mean: 

The credentials provided for the Salesforce source are invalid

I have multiple reports from SFDC which are connected to power BI. The scheduled refresh is set to evening 17.30 IST, but everyday the refresh gets failed and gives the below error message:-

Data source error: The credentials provided for the Salesforce source are invalid. (Source at https://login.salesforce.com/.). The exception was raised by the IDbCommand interface. Table: Double Down Opportunities.

Cluster URIWABI-NORTH-EUROPE-C-PRIMARY-redirect.analysis.windows.net

Activity IDfce11e1d-4d2e-4b3a-8a53-c9966867160a

Request IDca440e40-1a55-4254-3221-d15c13069825

 

When I try to refresh the data manually, everytime this error comes up with new table name of the SFDC report. Please help as this quite frustrating and a lot of manual effort.

Status: Investigating
Comments
v-robertq-msft
Community Support

Hi,

Can you check if you have 'API Enabled' in your org on the profile which you are using for authentication?  Was this working earlier?

https://help.salesforce.com/articleView?id=000326486&type=1&mode=1

 

Review below links that have similar issues and will help you:

https://success.salesforce.com/answers?id=9063A000000p8YZQAY

https://salesforce.stackexchange.com/questions/99900/oauth-issue-oauth-approval-error-generic

https://developer.salesforce.com/forums/?id=9060G000000Xaw2QAC

 

Hope the above information was helpful.

 

Best Regards,

Community Support Team _Robert Qin

v-robertq-msft
Community Support
Status changed to: Investigating
 
manishgaikwad87
Frequent Visitor

Hi,

 

Yes, we do have API enabled as we are using "Unlimited Edition" in our org.

 

To elaborate more, we have created a dataset wherein we have linked multiple SFDC reports to power BI. With the help of this dataset there are multiple dashboards which are been published and refreshed daily.

For the first few months, we do not encounter any issues and the dataset was getting refreshed properly. But now, almost everyday the scheduled refresh gets failed even after changing the time multiple times.

 

Is it because we have created multiple dashboards on this one dataset? Please advise.

 

v-robertq-msft
Community Support

Hi,

As far as I’m concerned, the interaction operations of the users within your tenant will also consume some resources that influence the data refresh. I suggest you to schedule the refresh time to midnight and check if it can succeed. If you still have this issue, I suggest you to open a support ticket to get direct help from the technical support team of Microsoft.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

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

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

Pierrick78
Frequent Visitor

HI,

I am encounering the same issue.

From Power BI Desktop I have a SalesForce report as a datasource, I am anle to refresh it.

But once published when I want to refresh, after 8 minutes I got this error (even though I filled in my credentials)

DataSource.Error:
<pii>Web.Contents failed to get contents from
'https://dematic.my.salesforce.com/services/data/v48.0/analytics/reports/00O2p000008XrGMEA0?includeDe...'
(404): Not Found</pii>.
DataSourceKind = <pii>Salesforce</pii>.
DataSourcePath = <pii>https://login.salesforce.com/</pii>.
Url = <pii>https://dematic.my.salesforce.com/services/data/v48.0/analytics/reports/00O2p000008XrGMEA0?includeDe...</pii>. .
The exception was raised by the IDbCommand interface. Table: AffairePerduesSF.

 

Please help !

manishgaikwad87
Frequent Visitor

Hi,

 

I have changed the scheduled refresh time to midnight and still facing the same issue. One more thing which i observed, during the start of the week i have to refresh the data manually many times and as the week passes the manual refresh numbers also gets reduced. On weekends usually i have to refresh the data manually once after it gets failed or the data gets auto refreshed. Not sure if this is something to look into.

v-robertq-msft
Community Support

Hi, 

For further research on this kind of refresh problem, I suggest you to open a support ticket to get direct help from the technical support team of Microsoft.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

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

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

Checklist
Advocate I

Hello,

 

We are experiencing exact same problem. Refresh succeeds in desktop, but the scheduled refresh fails. This issue started today, the scheduled refresh did work without issues about 1 year.