Authentication between cloud and on-premise

[sparkymark75]

We have the following setup;

• Active Directory On-Premise
• Azure AD (synchronized with the on-premise)
• On-Premise Dynamics CRM 2011

I'm trying to create a Flow which connects to an on-premise CRM web service and return the results. Whenever this runs it fails with a BadGateway error.

When setting up the Connections, do we use HTTP with Azure AD. and If so, do we use Connect directly or Connect using on-premises gateway? We currently have it setup with the latter using our previously configured data gateway (which works as I've used it for Power BI).

If I try and use the Connect directly option, we get an error about the resource principal not being found in the tenant. Just seems like there are so many moving parts and so many differing configuration options with no clear path on how to do anything when you stray from the well documented all in the cloud setup.

[a-ovbord · Accepted solution]

Hi @sparkymark75,

Unfortunately there is no simple solution to your setup.

Ideally you'd want to keep everything in the cloud, especially if you take into consideration latency issues between your on-prem data and the gateway you will have to setup which will be routed through a region designated data center (so even if it's installed on an on-prem server, it will be routed through a datacenter).

I'm including here a good article with best practices when it comes to creating apps:

https://powerapps.microsoft.com/en-us/blog/powerapps-canvas-app-coding-standards-and-guidelines/

Hope this helps.

Thank you,

Ovidiu

[sparkymark75]

Thanks. Sadly the answer I expected but didn't hope for.

So in summary; Power Apps is great if all your data sources are in the cloud. If you have anything on premise, you're going to struggle.