Showing results for 
Search instead for 
Did you mean: 
New Member

Licenses requirement for On-premises data gateway



I am trying to use on-prem data gateway with in PowerApps via O365 E1 license and got the following error "

Your license(s) doesn’t support use of gateways. To use this feature, start a trial." What license do I need to use this feature?


Community Support
Community Support



Yes, it is not available.


On-premises connectivity is not available for Office 365 Business, Office 365 Enterprise E1 or Office 365 F1 SKUs.


Basically you would require PowerApps for Office 365, or PowerApps plan 1, Plan 2, as listed in the pricing page:

PowerApps pricing


For the detailed PowerApps license information, see:

Licensing overview




Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I am getting the same error, however, in my case, while my account is licensed for O365 via E1, I also have a PowerApps Plan 2 license applied to the account as well.  Could the error be complaining about another account?  I'm not the one that originally set up the gateway.


I ran into the same issue.  I reviewed the licensing info you linked to, and would like confirmation.

From what I gather users of a PowerApp app require Plan 1, while developers require Plan 2. 

Do any of the E plans include an equavalent to PowerApps 1 or 2 Plans?

i.e. does E5 include Plan 2 and therefore allow a developer to use an On-Premise gateway?

Or is it that if you have an E1,E3 or E5 license you still need a PowerApps Plan to use/develop an On-Premise gateway?

I've signed up for trial PowerApps Plan 2, so for now I can access the SQL server via the gateway, so I know it does work with Plan 2, just want to know what my options are once that trial expires.


Advocate I
Advocate I

I'm not seeing any errors because I am on an E3 plan, but I have some users who are on 365 Business plans who are being sent to a trial page when they open my App.  Would this be because I am using an On-premises data gateway in this App?


 PowerApps Trial.jpg

Starting yesterday all of our users started getting prompts to sign up for the PowerApps trial.  Even though these users all have E3 licenses and the apps are Canvas apps that do leverage on prem SqlServer access. 

I'm not understanding why we're getting prompted for the trial?  Am I misreading the licensing documentation?  Or has anyone seen a tool that analyzes what 'premium features' you're using?

Yes - I'm with @jnickell!!!


My staff and I all have E3 licenses.  I have been able to confirm that we are prompted for a trial if we open any canvas app with an on-premise SQL Server connection. 


I really need to know what's going on so that I can make a decision - we can't use any of the apps that we've developed!  Am I going to have to scrape together an additional $40/user for a Plan 2 license on top of my E3 license costs?

@v-micsh-msft  - 


Can you confirm for @jnickell and I - 


Should a Office 365 Business E3 License be able to use Powerapss Canvas Apps with On-Premise data connections?

To my understanding now -

On-Premise Gateway connections are Premium and not included as part of the Office 365 E3 (or other) plans as the PowerApps plan included with that is specific to Office 365.  You need P1 or P2 to use the premium connection.

All Apps with the Premium connection and no license will prompt users to sign up for a Trial.


Bites!! Smiley Mad

Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

@NEPatton @jnickell 

If you use the PowerApps with an On Premise Gateway to connect to say a SQL database you need a PowerApps Plan 1 license for each user using the app.  E3 Licenses don't include PowerApps 1 or 2 plans.


The following is from


PowerApps standalone Plan 1 and Plan 2

Standalone PowerApps plans provide users the ability to create and run apps across data sources that extend beyond Office 365, such as Salesforce, on-premises and custom data sources. These plans also include access to the Common Data Service for Apps to store and manage data. Learn more about the Common Data Service for Apps here.

  • Microsoft PowerApps Plan 1 subscriptions are for users who need to run canvas apps and access on-premises data, data in custom applications and cloud services using premium connectors.
  • Microsoft PowerApps Plan 2 subscriptions are for users and administrators who need access to more capabilities. These users can run model-driven apps that can include custom code plug-ins and real-time workflows. These users have access to important management capabilities like viewing usage and setting policy.




Helpful resources

October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022


Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (2,390)