cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mogulman
Level 8

Confused on PowerApps Licensing Changes.

I am confused on PowerApps licensing changes that go into effect in October 2019.  Let me describe my scenario.

 

1. We are a small legal business with less than 10 employees.

2. We switched from Salesforce to Microsoft about 2 years ago.

3. We all have Microsoft 365 Business licenses which comes with PowerApps.

4. I'll be using Azure SQL DB for all data.  This provides incredible flexibility for robust business apps.

5. I'm temporally developing app using On-premise Data Connector and SQL Server.  This allows me use SQL Profiler to debug problems and optimize performance.  I'll be switching to Azure SQL DB in the next month.

 

Switching to Microsoft from Salesforce provides a lot more flexibility.  Azure Functions is great to extend PowerApp capability.  I'm not using HTTP request.

 

What impact will the October changes have in my case?

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Confused on PowerApps Licensing Changes.

For Azure SQL you'll be grandfathered in for apps that exist on Oct 1, but won't be able to build any new apps without premium licensing.  And yes, the gateway should be usable until next January if you were already using it by this spring.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

8 REPLIES 8
Dual Super User
Dual Super User

Re: Confused on PowerApps Licensing Changes.

When you say you switched from Salesforce to Microsoft it implies you are using Dynamics 365 CRM, which would be the equivalent product.  Is that true or are you just using regular Microsoft 365?  The regular PowerApps license for M365 doesn't inlcude a premium license, which would be required if you are using an on-premises gateway with SQL.  So again I suspect you are using CRM licensing.  If that is the case then you shouldn't have an issue because the Dynamics license for CRM includes the equivalent of a premium P2 license today and that isn't changing significantly on October 1.

 

You should also be aware that MS has grandfathered in any apps taht are using SQL on October 1 to not require premium for SQL for 5 years.  That grandfathering wouldn't cover the use of the on-premises data gateway. Azure SQL down't require the gateway, but will require a premium license for anything built after Oct 1.

 

So a lot really depends on what license you actually have.  Could you supply more information?



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
mogulman
Level 8

Re: Confused on PowerApps Licensing Changes.

I'm not using Dynamics CRM.  I'm just using Microsoft 365 Business.  I started using the On-Premise Gateway and SQL Server.  I think I'm grandfathered in until early next year.  I'm switching to Azure SQL DB in September so I think I should be grandfathered in for 5 years.

Dual Super User
Dual Super User

Re: Confused on PowerApps Licensing Changes.

For Azure SQL you'll be grandfathered in for apps that exist on Oct 1, but won't be able to build any new apps without premium licensing.  And yes, the gateway should be usable until next January if you were already using it by this spring.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Community Support Team
Community Support Team

Re: Confused on PowerApps Licensing Changes.

Hi @mogulman ,

Do you mean that you purchase Office 365 license for your account rather than standalone PowerApps license?

 

If you only own have Office 365 license for your account, I think you would not be able to use the On-premises data connector and Azure SQL within your app since October 2019.

 

Currently, the On-premises Data connector, Premium connector and Customer connector in PowerApps are not supported within Office 365 licenses. And Effective October 1, 2019, the Azure SQL connector would be reclassified from Standard to Premium.

So if you want to access all Premium, on-premises and custom connectors within PowerApps after October 1, 2019, you must purchase a standalone PowerApps or Flow plan license for your account.

 

More details about functionality supported under Office 365 license includes PowerApps, please check the following article:

https://docs.microsoft.com/en-us/power-platform/admin/pricing-billing-skus#powerapps-for-office-365

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mogulman
Level 8

Re: Confused on PowerApps Licensing Changes.

@v-xida-msft I purchased Microsoft 365 Business licenses.  The license includes PowerApps.  That license type is not listed in the link you provided.

 

Late last year I received a notification that the on-premse connector would require a special license after Jan 2020.  Since I'm migrating app to Azure SQL DB this week it is not a big deal. 

 

I find the SQL Profiler an incredibly valuable tool to debug and optimize performance.  I may need to get one premium license to get this capability.   I would debug and optimize performance using an on-premise SQL Server and migrate to Azure SQL DB.  It would be nice if MS offered a developer license for this purpose.

Dual Super User
Dual Super User

Re: Confused on PowerApps Licensing Changes.

The Microsoft 365 Business license would be the same as either the Office 365 Business Essentials or Business Premium license mentioned in the article.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
bb234
Level: Power Up

Re: Confused on PowerApps Licensing Changes.

Just hoping to verify our specific situation with re PowerApps licensing, our scenario as below, this is similar to the OP

a) we are on Office 365 E3 plan

b) Trialled powerapps Jan 2019 with Canvas app + On prem SQL

c) Changed to new licensing i.e. PowerApps P1 ~ March 2019, i.e. $10 per user per month

d) Now with new changes, its very confusing as to what we need to do to stay licensed. Do we need to transition to $40 per user per month plan or go to the $10 per user per app per month.

I cannot find this clearly referenced in the MS blog post on the matte i.e. since we are using the onprem connector, do we need to go to premium licensing i.e. $40 per user per month?

Happy to get our ITS to raise a ticket, but we need this clearly explained to sell this to stakeholders.

Dual Super User
Dual Super User

Re: Confused on PowerApps Licensing Changes.

You will eventually need to go to the $40 per user per month plan unless you only have one or two apps.  If its less than 4 it may be cheaper to go to the $10/app/user/month plan.  But you will have access to your original plan until at least next October, 2020 since you are already on a P1.  Its only after that, or the expiration of your license whichever is longer, that you will have to migrate to a new plan. The app you originally tested with using SQL will also be covered until October, 2024.  Up until October the SQL connector was a standard connector and existing apps that used it will continue to see it as a standard connector for 5 years.

 

So to summarize:

  • You keep your existing licensing ($10 per user) until it expires or next October, whichever is longer.
  • SQL apps are covered as standard license for 5 more years
  • After next October you will need to move to either the $40 per user or $10 per app per user plan.


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (7,197)