License Help

(1) Share

Report

Posted on by EpicTriffid

345

Hi all,

So, I found out today about Microsoft's update concerning Azure SQL connectors moving to premium. To say I'm angry about this is an understatement. Getting users invested in a product, only to have that product now held in ransom unless they upgrade is abhorrent. But that's something for me to vent about seperately.

In order to mitigate the effect of this, and hopefully not require scrapping months of work, I was looking at the licensing options for PowerApps. I just need some clarification on which license to get.

I have one app that should be accessed by around 40-50 users on possibly a day basis. It has a connection to an SQL db on Azure, and uses 4 flows. In this case would a "per app" plan be suitable, or would i need to get the "per user" plan?

Thank you!

Categories:

Connectors

General Questions

All responses (6)

Answers (1)

timl 34,933 Super User 2025 Season 1 on at

Like (0)

Report

Re: License Help

Hi @EpicTriffid

Thanks for the update. I'm really glad that MS confirmed the exemption due to the app id not changing. Given the increase in pricing, that's a really valuable extension!
EpicTriffid 345 on at

Like (0)

Report

Re: License Help

Thank you for all your support. I contacted MS support and received this reply:

"Apps and flows created prior to October 1, 2019, using the SQL, Azure, and Dynamics 365 connectors has received an extended transition period until October 1, 2024.

During this time, these qualifying apps and flows will be exempt from the Premium connector licensing requirements for the reclassified connectors."

This means that if the App ID hasn't changed, you are eligible. No need to buy a premium license just yet!
Verified answer

timl 34,933 Super User 2025 Season 1 on at

Like (0)

Report

Re: License Help

Hi @EpicTriffid

I'm pretty sure that the "per app" license allows you to call stored procedures via Flow because the terms on the license page states the following permitted use - "Microsoft Flow use rights including premium connectors".

With regards to the extension period, I would raise a support ticket via the 'create support ticket' button here.

https://powerapps.microsoft.com/en-us/support/

If you have an app in development which has previously connected to SQL Azure, it might be case that you can have the extension period, provided that the app id hasn't changed. Good luck with this.
EpicTriffid 345 on at

Like (0)

Report

Re: License Help

Thankyou for the replies.

My flows are triggering Stored Procedures linked to the same sql tables I'm connected to in the app. Would this still allow me to use them under a Per App license?

Unfortunately, although I've previously connected to SQL Azure before the cut off date, the app is still in development , so It's had to be republished since that point, which I'm assuming then loses me the extension period? Unless I should still have it?
v-xida-msft on at

Like (0)

Report

Re: License Help

Hi @EpicTriffid ,

I agree with @timl 's thought almost. If the canvas app you created is before October 1, 2019, you would receive an extended transition period until October 1, 2024. During this time, these qualifying apps and flows will be exempt from the Premium connector licensing requirements for the reclassified connectors.

Please check the following article for more details:

https://docs.microsoft.com/en-us/power-platform/admin/powerapps-flow-licensing-faq#how-does-the-change-to-powerapps-and-microsoft-flow-use-rights-for-office-365-applications-affect-me-if-i-purchased-the-subscriptions-prior-to-oct-1st-2019-will-my-existing-powerapps-applications-and-microsoft-flow-workflows-continue-to-work

Do you add flow conections within your canvas app? If you add flow connections in your app, please make sure the flow use the same data sources for triggers or actions as the PowerApps application, then I think the 'Per App Plan' would be suitable for your scenario. Othereise, you need also to purchase standalong Microsoft Flow license.

Please check the following article for more details:

https://docs.microsoft.com/en-us/power-platform/admin/powerapps-flow-licensing-faq#are-full-microsoft-flow-capabilities-included-in-powerapps-licenses

Best regards,
timl 34,933 Super User 2025 Season 1 on at

Like (1)

Report

Re: License Help

Hi @EpicTriffid

I completely understand your anger about the licensing situation. In your scenario, I agree that the 'per app' license is the best plan.

But before you buy any licenses, have you actually published your app? There is a 5yr transition period for existing users, so you might find that you're exempt from these new rules.

In addition, apps and flows created prior to October 1, 2019 which are using these connectors will receive an extended transition period until October 1, 2024. During this time, these qualifying apps and flows will be exempt from the Premium connector licensing requirements for the reclassified connectors.

https://docs.microsoft.com/en-us/power-platform/admin/powerapps-flow-licensing-faq#how-does-the-change-to-powerapps-and-microsoft-flow-use-rights-for-office-365-applications-affect-me-will-my-existing-powerapps-applications-and-microsoft-flow-workflows-continue-to-work