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 / Power Apps in Power BI...
Power Apps
Answered

Power Apps in Power BI licensing

(0) ShareShare
ReportReport
Posted on by MarkSL 27

Hi,

 

Apologies for asking a Power Apps licensing question, there seem to be more than a few already...

 

First off, we are completely new to Power Apps.  However we do have Power BI Premium with 500 users.

 

We now want to start integrating Power Apps into our Power BI reports, to allow the user to write comments back to our SQL database.

 

Our users are mostly on 365 E3 or Business Standard licenses which I believe will allow them to access a basic Power App, but not one which uses a Premium Connector which I understand all SQL (On Premise or Azure) are?

 

Would we therefore need to purchase 500 Per App plans at £7.50 per user per month?  Seems quite a price to allow them to write some comments back to SQL?  Or is it just the App developer that needs one of these?

 

Many thanks in advance,

 

Mark

Categories:
Governance & administering
  • Verified answer
    ChrisPiasecki Profile Picture
    ChrisPiasecki 6,428 Most Valuable Professional on at

    Hi @MarkSL,

     

    You are right that each user would require a premium license to use the SQL Server connector if directly writing to the database.

     

    What you could do is use an intermediate data store such as a SharePoint list to hold the comments. A Power Automate flow can be setup by a user that has a Flow Per User premium license to retrieve the record from the SharePoint list and save it in a SQL database.

     

    It's not the most elegant and it wouldn't be synchronous/real-time, but it would avoid having to license each user for premium Power Apps.

     

    ---
    Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

  • MarkSL Profile Picture
    MarkSL 27 on at

    Hi @ChrisPiasecki 

     

    Thanks for the reply. 

     

    I did briefly look at this 2 years ago and I am pretty sure that Azure SQL was a standard connector back then?  

     

    Regardless, it looks like the Sharepoint List with a flow to pass into SQL might have to be the solution.  I am not expecting it get hard usage, possibly something in the region of 50 inserts a day.  

     

    I presume the Sharepoint List to SQL Flow is well established as it were and not likely to have its capabilities removed?  I imagine many must be using this as a solution?

     

    So aside from single the Flow Premium license, would myself or my team as developers require a Power Apps Per App plan license, or should the standard PowerApps access as part of my E3 be enough?

     

    Thanks again for your inputs, 

     

    Mark

     

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 342 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 271

#3
Mohsin Ali Profile Picture

Mohsin Ali 223

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