web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / License for using SQL ...
Power Apps
Unanswered

License for using SQL Server Premium Connector instead of SharePoint Connector

(0) ShareShare
ReportReport
Posted on by johnjohn123 3,514

We have developed many Power Apps for SharePoint, and now want to start a new Power Apps for SQL Server. now seems the connector for SQL will require a Premium account.. so is this premium account required for all the users who will be accessing the Power Apps? or only for the service account user?

 

second question, using the SharePoint connector, each use who use the Power Apps will connect to the SharePoint list using their Identity ... so is this the same as for SQL server? or all users will access the database using the service account identity ?

 

Thanks

Categories:
Building Power Apps
I have the same question (0)
  • Pstork1 Profile Picture
    Pstork1 69,129 Most Valuable Professional on at

    If you use a SQL data source in a Power App then every user will require a Premium license, either a per user or per app license.

    The SQL connector can create either explicit connections or implicit connections depending on the way you authenticate the connector.  Read more here: Use Microsoft SQL Server securely with Power Apps - Power Apps | Microsoft Docs . Explicit connections use the user's credentials.  Implicit connections use a shared connection account credentials.

  • johnjohn123 Profile Picture
    johnjohn123 3,514 on at

    @Pstork1 so even if i use Implicit connector i need to license each user who will be accessing the Power Apps?

  • Pstork1 Profile Picture
    Pstork1 69,129 Most Valuable Professional on at

    Yes, all users will need a license because they are using the connector.  It doesn't matter whether the connection is Implicit or Explicit.  Its still using a Premium connector.  The only difference is whether the connector uses that user's credentials or a set of credentials stored in the connector.  The premium license is still required by all users running the app.

  • junastrogal Profile Picture
    junastrogal 2 on at

    What particular license is needed to properly connect to SQL Server Premium? Is E3 per user enough?

  • Pstork1 Profile Picture
    Pstork1 69,129 Most Valuable Professional on at

    E3 is not enough.  Each user will need either a per user or per app license to be able to use an App containing a SQL connector.

  • clbamford Profile Picture
    clbamford 11 on at

    Pay-As-You-Go licensing is also an option if you don't want to assign individual user licenses to every user of the app. This licensing model might be a better option for you if the app has a mix of regular users & occasional users and/or if you don't want to have to manage license assignments when users get added/removed from the app.

     

    More info on this here and here.

  • Pstork1 Profile Picture
    Pstork1 69,129 Most Valuable Professional on at

    That is true.  But please remember that removing a user from the app doesn't add the per app license back to the pool to be re-assigned for a minimum of 90 days. It will only charge for user's who use the app within a 30 day billing period, But the pool is not particularly dynamic.

  • kinipradeep80 Profile Picture
    kinipradeep80 2 on at

    If we use Azure Database, do we need premium connectors for every user connecting to Azure Database from Power Apps?

  • Pstork1 Profile Picture
    Pstork1 69,129 Most Valuable Professional on at

    Yes you do. Its the connector that makes the license necessary. It doesn't matter where the SQL data base is located.

  • matthhias Profile Picture
    matthhias 48 on at

    How is it for a Power App embedded in Power BI? With "embedded" I refer to the PowerApp visual in PowerBI. I built a solution where I started there and store user entries in SQL server.
    Do the PowerBI users also need PowerApp Premium licenses in this case?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 536

#2
WarrenBelz Profile Picture

WarrenBelz 426 Most Valuable Professional

#3
Haque Profile Picture

Haque 305

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans