D365 FnO Connector error : Could not retrieve values, BadGateway

Hello Everyone,

Recently come across with an issue with D365FO connector from an cloud deployed instance which was used to consume the odata services from azure logic app and power app

Issue:

Recently got an issue with D365FO connector from an cloud deployed instance which was used to consume the odata services from azure logic app and power app. It was all working fine and one fine day all of a sudden the power app and the logic app stopped fetching the data from FnO and giving the error as “Could not retrieve values, Badgateway More diagnostics information:  x-ms-client-request-id is ‘xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxx’.

Root cause:

I started troubleshooting and tried to run the web instance and instance of FO is also not running with https and its only running in private. And realized certificates would have expired and checked the same in LCS and the certificates were been expired.

Solution:

I ran the Rotate certificates/Rotate Secrets using the LCS VM options, and checked for web instance which started working and the Bad gateway issue also has been resolved.

You can refer standard Microsoft documentation for the process to Rotate Secrets for cloud deployed D365FO instance.

Thanks.