Schedule failed - Data source error: The credentials provided for the Salesforce source are invalid.

[KSI051]

@PBICommunity I have a report published in Power Bi for which I have "Scheduled Refresh" on but many times it gets failed. Checked the error message it shows 

Data source error: The credentials provided for the Salesforce source are invalid.....

Not really sure about the reason for invalid credentials as it even gets perfectly scheduled sometimes in a day. Below is the screenshot attached, would need to understand the problem here and 

[v-cazheng-msft]

Hi @KSI051,

According to the official document, if you see the error “The credentials provided for the dataset are invalid. Please update the credentials through a refresh or in the Data Source Settings dialog to continue.”, you could try these solutions. Troubleshooting Power BI gateway (personal mode) - Power BI | Microsoft Docs

• The usernames and passwords that you used to sign in to data sources aren't up to date. In Power BI, go to refresh settings for the dataset. In Manage Data Sources, select Edit credentials to update the credentials for the data source.
• Mashups between a cloud source and an on-premises source, in a single query, fail to refresh in the gateway (personal mode) if one of the sources is using OAuth for authentication. An example of this issue is a mashup between CRM Online and a local SQL Server instance. The mashup fails because CRM Online requires OAuth. This error is a known issue, and it's being looked at. To work around the problem, have a separate query for the cloud source and the on-premises source. Then, use a merge or append query to combine them.

Best Regards,                                                     

Community Support Team _ Caiyun

[KSI051]

Hello Team,

Not really sure if it helps because its not something that I am facing for every scheuled time. Some times it gets refreshed with the same credentials. Please refer screenshot below, today, twice it was failed while it was successful twice.

Credentials is same for all the schedular that I have.

[KSI051]

Hello Team,

Waiting for an update on the mentioned issue.

Regards,

Keshav Singh

[KSI051]

@PBICommunity would need help to understand the problem here and hopefully get the same resolved.

Regards,

Keshav Singh

[KSI051]

@v-cazheng-msft would reqeust for your support here, as I am still facing same issue

Regards,

Keshav Singh

[KSI051]

@MicrosoftLC @v-cazheng-msft @PBICommunity not really sure who may assist here, but recently the issue has increased a lot. Would need some solution urgently.