The credentials provided for the Dynamics365BusinessCentral source are invalid.

[mpmsltd]

Hi,

I'm connecting my dataset to multiple sources, including Dynamics BC. 

For the reports that only use Dynamics BC I have no problem with the scheduled refresh. For the ones that have other sources such as Excel, SQL or SAP Hana, I have an error on the refresh : 

The credentials provided for the Dynamics365BusinessCentral source are invalid. (Source at Dynamics365BusinessCentral.)

Does anyone know how to get this fixed?

Thanks!

[mpmsltd]

Thank you @v-kkf-msft I tried your solution and it didn't work. My expected result is to be able to refresh my data automatically on a schedule.

Here is the error that I'm getting:

Underlying error code:	-2147467259
Underlying error message:	The credentials provided for the Dynamics365BusinessCentral source are invalid. (Source at Dynamics365BusinessCentral.)
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind:	Dynamics365BusinessCentral
Microsoft.Data.Mashup.CredentialError.DataSourceOriginKind:	Web
Microsoft.Data.Mashup.CredentialError.DataSourceOriginPath:	https://api.businesscentral.dynamics.com/v2.0/PRODUCTION/OData/TRCPostedInvoice('SI1004007')/QRCode?...'
Microsoft.Data.Mashup.CredentialError.DataSourcePath:	Dynamics365BusinessCentral
Microsoft.Data.Mashup.CredentialError.Reason:	AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources:	[{"kind":"Dynamics365BusinessCentral","path":"Dynamics365BusinessCentral"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason:	AccessUnauthorized
Cluster URI:	WABI-US-EAST2-redirect.analysis.windows.net

[v-kkf-msft]

Hi @mpmsltd ,

It looks like you are using both on-premises and cloud sources in a dataset, please make sure your gateway is configured correctly.

1. Under Gateway Cluster Settings, select Allow user's cloud data sources to refresh through this gateway cluster > Apply.

2. Add both the cloud data source and the on-premises source to your gateway. Or for the on-premises source, select the gateway associated with this data source, then edit the cloud data source credentials under Data source credentials. Make sure privacy levels for both cloud and on-premises data sources are set appropriately to ensure the joins are handled securely.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.