Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Re: Licenses requirement for On-premises data gateway

Hello folks, 


Please refer to this blog announcing changes to the licensing with respect to office only licenses. Customers who were going to be impacted were informed through message center in office portal.


Also since most of the folks on this thread are trying to get access to on-premises data,  a plan 1 license should be able to get you access on-premises data using an on-premises gateway. Please refer the plan comparison page where these features are called out. 




Level 8

Re: Licenses requirement for On-premises data gateway

Thank you @RandyHayes and @ElevenTech !!!!


I think I was very confused about what was included with the E3 license since it isn't clearly spelled anywhere.


Thank you for taking the time to help me out.

Level: Powered On

Re: Licenses requirement for On-premises data gateway

Thanks, for the followup.  I was seeing the documentation about the licensing change but there is still documentation that makes it appear as though OnPrem connections do not require a P1 license


I did open a support case where I was told that we should have received an automatic extension which we did not.


Not applicable

Re: Licenses requirement for On-premises data gateway

The main issue we are facing is that it does not appear that this reference from the blog post on licensing changes has actually happened.


"Customers with active users of these features will get an automatic extension until January 31, 2020 or the expiration of their existing Office 365 subscription term (whichever is longer). "


All E3 using On Prem connections for 12months and now being prompted for trials and hitting issues creating new connections based on the advertised auto extension not happening. Support case logged - bounced from Exchange / Dynamics, PowerApps then on to Licensing..  


If you were using a data gateway in 2018 I'd suggest logging a support case to ensure you receive the extension to give you time to consider moving your sql resources to Azure during 2019.

Super User
Super User

Re: Licenses requirement for On-premises data gateway


Agreed!  We noticed as well that places where we were "active users" were prompted to start a trial.  I have a feeling that doing so would only complicate issues.  Perhaps starting a trial is the start of the 12 month grace period.  It has not been a pressing issue on the Apps where we were using still on the fence.


For reference - the one App we had that had this in play was a Company directory App.  The company had more people than they had users (i.e. some were just employees and didn't have any Office 365 licenses to speak of) and as such, they have an on-premise SQL database that is populated by their in-house HR department with the employee names.  Our App queried the in-house database and then combined the results with Office 365 lookups where applicable and displayed for them a nice company directory for all users on all devices.

When this license changed for the On-Prem gateway, that App stopped working.  It was not feasible for the company to spend an additional $700 per month (100 users * $7 per month) just to have a Company Directory in their hand.  The App is scrapped for now.

Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

Helpful resources

New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,950)