cancel
Showing results for 
Search instead for 
Did you mean: 

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

@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 

 

KSI051_0-1660615092964.png

 

Status: Investigating

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

Comments
v-cazheng-msft
Community Support
Status changed to: Investigating

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
Regular Visitor

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_0-1660620515512.png

 

KSI051
Regular Visitor

Hello Team,

 

Waiting for an update on the mentioned issue.

 

Regards,

Keshav Singh

KSI051
Regular Visitor

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

 

Regards,

Keshav Singh

KSI051
Regular Visitor

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

 

Regards,

Keshav Singh