cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Withnail
Level: Power Up

PowerApps License Pricing: building with Microsoft SQL Server

Having spent an hour researching pricing, I am (yet again with Microsoft) completely confused. 😧

 

I have office 365 Business Essentials which costs GBP £3.80 per month and this gives me "PowerApps for Office 365". My reading is that this allows you to connect to things like SharePoint Lists and Excel workbooks but not the CDS or any databases.

I believe that, in order to create a canvas app that connects to MS SQL Server (online) for CRUD operations, I have to purchase the PowerApps Plan 2 licence which costs £30.20 per month. Is that correct?

There is a free 3 month period. Can I develop the app in those 3 months and then turn off this licence? 😀 And then turn it back on when I want to update it?

 

I want two other users to be able to run the app. Can they use their current "PowerApps for Office 365" or do I need a Plan 1 licence for each? (Having now created a trial tenant and then connected to SQL Server, I get this message: "Apps that use this connector will require end users to have at least Power Apps Plan 1." So I think I've answered my own question - can someone confirm?)

 

Thanks!

 

The biggest hurdle to developing apps in PowerApps is the pricing / licensing model. 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: PowerApps License Pricing: building with Microsoft SQL Server

Hi @Withnail 

I get how confusing this is.

Plan 1 and 2 licenses no longer exist - they've been superseded by the per app and per user licensing model.

In your case, the cheapest way to use MS SQL Server is to purchase per app licenses at £10/user/month. As you've found out, your other 2 users will also need a license.

You need a license to run and develop your app. So if you develop your app with a trial license and the trial expires, you'll no longer be able to run your app (it won't load).

Feel free to post back if you need any clarification on this.

View solution in original post

Super User
Super User

Re: PowerApps License Pricing: building with Microsoft SQL Server

Hi @Withnail 

Unfortunately, Office 365 Business Essentials doesn't include the option to connect to SQL Server.

I think they haven't completely changed the dialogs, which is why we still references to Plan 1 and Plan 2.

View solution in original post

4 REPLIES 4
Super User
Super User

Re: PowerApps License Pricing: building with Microsoft SQL Server

Hi @Withnail 

I get how confusing this is.

Plan 1 and 2 licenses no longer exist - they've been superseded by the per app and per user licensing model.

In your case, the cheapest way to use MS SQL Server is to purchase per app licenses at £10/user/month. As you've found out, your other 2 users will also need a license.

You need a license to run and develop your app. So if you develop your app with a trial license and the trial expires, you'll no longer be able to run your app (it won't load).

Feel free to post back if you need any clarification on this.

View solution in original post

Withnail
Level: Power Up

Re: PowerApps License Pricing: building with Microsoft SQL Server

@timl - thanks so much! That is much clearer, and cheaper! 😀

 

Just one other thought: we all have Office 365 Business Essentials which includes 'PowerApps for Office 365'. I'd noticed that this was a stripped down version of P1 and P2 licences i.e. without database connectivity. Is it still the case that this is different to the new $10/month licence? Or (hope against hope) have I already got a fully fledged PowerApps licence within Office 365?

 

BTW, when I try to connect to SQL Server it still says it's a "Premium connection will start a Power Apps Plan 2 trial." 🤔

Super User
Super User

Re: PowerApps License Pricing: building with Microsoft SQL Server

Hi @Withnail 

Unfortunately, Office 365 Business Essentials doesn't include the option to connect to SQL Server.

I think they haven't completely changed the dialogs, which is why we still references to Plan 1 and Plan 2.

View solution in original post

Withnail
Level: Power Up

Re: PowerApps License Pricing: building with Microsoft SQL Server

Thanks, yes that makes sense.

Helpful resources

Announcements
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

thirdimage

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 (7,725)