cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sparkymark75
Frequent Visitor

Authentication between cloud and on-premise

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.

1 ACCEPTED SOLUTION

Accepted Solutions
a-ovbord
Community Support
Community Support

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

View solution in original post

2 REPLIES 2
a-ovbord
Community Support
Community Support

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

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.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (5,043)