PowerApps License Pricing: building with Microsoft SQL Server

Like (0) Share

Report

Posted on 22 Jan 2020 10:33:13 by Withnail

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.

Categories:

General Questions

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

timl 35,805 Super User 2025 Season 2 on 22 Jan 2020 at 14:22:37

Like (1)

Report

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.

Was this reply helpful? Yes No
Withnail 10 on 22 Jan 2020 at 15:04:21

Like (0)

Report

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." 🤔

Was this reply helpful? Yes No
Verified answer

timl 35,805 Super User 2025 Season 2 on 22 Jan 2020 at 16:29:50

Like (1)

Report

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.

Was this reply helpful? Yes No
Withnail 10 on 22 Jan 2020 at 16:32:30

Like (0)

Report

Re: PowerApps License Pricing: building with Microsoft SQL Server

Thanks, yes that makes sense.

Was this reply helpful? Yes No