Licenses requirement for On-premises data gateway

(1) Share

Report

Posted on by alanw707

Hi,

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (0)

v-micsh-msft on at

Like (2)

Report

Hi,

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

Regards,

Michael

Was this reply helpful? Yes No
BrandonMurray 37 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
BrendonA 15 on at

Like (1)

Report

Hello,
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.
Thanks,

Was this reply helpful? Yes No
DaveM 54 on at

Like (1)

Report

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?

Was this reply helpful? Yes No
jcnickell 62 on at

Like (1)

Report

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?

Was this reply helpful? Yes No
NEPatton 360 on at

Like (1)

Report

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?

Was this reply helpful? Yes No
NEPatton 360 on at

Like (1)

Report

@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?

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (2)

Report

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.
https://techcommunity.microsoft.com/t5/Office-Retirement-Blog/UPDATED-Updates-to-Microsoft-Flow-and-PowerApps-for-Office-365/ba-p/289589
All Apps with the Premium connection and no license will prompt users to sign up for a Trial.

Bites!!

Was this reply helpful? Yes No
BrendonA 15 on at

Like (2)

Report
@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 https://docs.microsoft.com/en-us/power-platform/admin/pricing-billing-skus
-------
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.
-------

Was this reply helpful? Yes No
SrikumarNair Microsoft Employee on at

Like (1)

Report

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.

Thanks,
_Sri

Was this reply helpful? Yes No