how the powerapps data source make a connection with business central (on-premises). and how to resolve this powerApps error code. 502

(0) Share

Report

Posted on by KanishkaMohan

{
"error": {
"code": 502,
"source": "india-001.azure-apim.net",
"clientRequestId": "a48c02ef-959b-4ece-9cd7-6bb59ea89970",
"message": "BadGateway",
"innerError": {
"status": 502,
"message": "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.\r\n inner exception: An error occurred while sending the request.\r\n inner exception: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.\r\n inner exception: The remote certificate is invalid according to the validation procedure.\r\nclientRequestId: a48c02ef-959b-4ece-9cd7-6bb59ea89970",
"error": {
"message": "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.\r\n inner exception: An error occurred while sending the request.\r\n inner exception: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.\r\n inner exception: The remote certificate is invalid according to the validation procedure."
},
"source": "dynamicssmbonprem-si.azconn-si.p.azurewebsites.net"
}
}
}

Session ID: 37d0e819-b5f3-469f-9686-599745501241

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Marco Mels on at

Like (1)

Report

RE: how the powerapps data source make a connection with business central (on-premises). and how to resolve this powerApps error code. 502

Hello,

The problem seems to be related to the SSL cert. Are you using a self signed cert and what type of authentication method?

Thanks.

Was this reply helpful? Yes No
Verified answer

Tabrez Ajaz 785 on at

Like (1)

Report

RE: how the powerapps data source make a connection with business central (on-premises). and how to resolve this powerApps error code. 502

Hi @kanishka,

Ask your IT Team for Public SSL Certificate, and configure it for Business Central Web Client from IIS Manager and define it in the binding.

Once Done, make sure to do following changes on Business Central Server Instance:

* Change your client credential type to NavUserPassword

* Add Certificate Thumbprint

* Enable SAOP and oData services

Do following change in navsettings.json available at location "C\inetpub\wwwroot\BC_Folder":

* "ClientServicesCredentialType": "NavUserPassword"

Enjoy and confirm if this solution works for you!

Was this reply helpful? Yes No
Suggested answer

KanishkaMohan 5 on at

Like (0)

Report

RE: how the powerapps data source make a connection with business central (on-premises). and how to resolve this powerApps error code. 502

I already tried earlier and worked.

Was this reply helpful? Yes No

Join the conversation

Community site session details

how the powerapps data source make a connection with business central (on-premises). and how to resolve this powerApps error code. 502

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

how the powerapps data source make a connection with business central (on-premises). and how to resolve this powerApps error code. 502

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates