PowerApps licensing-Office E3 and SQL

(0) Share

Report

Posted on by nihar

Dear Experts,

I have been looking into PowerApps licensing for one of my users and am really confused.

One of my users has only Office 365 E3 license but she is able to create apps using the SQL connector. I have verified that she does not have PowerApps/user or a PowerApps/app license. I was under the assumption that we need a PowerApps/user or a PowerApps/app license to use the premium connectors(SQL). Can you please help me understand this behavior ?

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

LaurensM 12,516 Moderator on at

Like (1)

Report

Hi,

As an Office 365 E3 user, you will need a license in order to create or use apps with premium connectors. However, as a Power Apps developer you could leverage the Power Apps developer plan or the Power Apps Trial license in order to try out the development with premium connectors.

As an IT admin you can check the currently active licenses via Azure AD. The user can also see the active licenses within the Power Platform, by selecting the gear icon on the upper right corner and clicking on 'Plans'. It would also be worth checking whether a Pay-As-You-Go subscription has been set up in that environment - that could also explain the access to premium features.

The developer can start trying out the features with these plans but will need a premium license down the road, albeit Per User, Per App or Pay-as-you-go (environment level).

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!

Was this reply helpful? Yes No
nihar 25 on at

Like (0)

Report

Hi @LaurensM Thank you for your response. I have already verified the user's current license from Azure.
Nothing in here should give her access to use premium connectors,

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report
At first glance, I would also not expect access to premium connectors. The remaining possibilities I think of are:

The user is developing in their own Developer Environment

A pool of Per App licenses was available within the environment and assigned (automatically) to the user. (Can be checked in the Admin Center -> license consumption tab -> under billing)

The environment has an active Pay-As-You-Go subscription

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report

Hi @nihar

Without a per user or per app license, it's possible for users to create or edit apps with premium connectors (SQL Server, Dataverse, etc). That's most likely the behaviour that your user is seeing.
When your user runs the app or shares it with others, that runtime usage will definitely require a per user/per app license, trial, or other suitable premium license.

Was this reply helpful? Yes No
nihar 25 on at

Like (0)

Report

HI @timl and @LaurensM ,

Thank you for your suggestions !

I have checked and verified the following -
- The user is developing in a sandbox environment
- The user can share apps with her colleagues
- The environment is not setup for per app license or Pay-As-You-Go

I believe that the user may have signed up for trial license. However I am not able to validate this in the Azure portal. My understanding is that any user with a trial should be available in the - "Microsoft Power Apps Plan 2 Trial" section in the license page. However the user is no there too.

Is there any other way for me to confirm if the user is using a trial license ?

Was this reply helpful? Yes No