Power App licensing

[FrancescoSCP]

Hi,

i have a customer with about 150 Power BI Pro licenses.
I want to create an App with Power App to allow to every user to write back some data on SQL Server On Prem and embed it in a Power BI Report.
I know that the connector for SQL Server On Prem is "premium" and costs around 20$/user/month, but the question is if i develop the App with one user, every other Power BI Pro user needs Power App Premium license to use that app?

Thanks in advance.

Francesco

[aj1973]

Hi @FrancescoSCP 

Only for the ones who are going to use the App to write back data to SQL Server.

[FrancescoSCP]

Hi @aj1973, thanks for your reply!

All users are sales representatives and should enter their daily visit data into SQL Server. This means 150 users for about $20 per month, or approximately $33,000 in a year. Are there any other solutions

Regards,
Francesco

[aj1973]

If your customer has Microsoft 365 E3 type of Licences then Power Apps is included

https://www.microsoft.com/en-ca/microsoft-365/enterprise/microsoft365-plans-and-pricing

[FrancescoSCP]

But not Power Apps Premium, which is required by the on-premises SQL Server connector, right?

Regards,

Francesco

[aj1973]

Better check with your client. The connector is the Power BI Gateway which is already installed I suppose. I don't think you need Premium for that.

[pstork1 · Accepted solution]

They can reuse the Power BI Gateway, but they will still need Power Apps Premium licensing to use the SQL connector. So yes, any user who uses the app will need either a Power Apps Premium license or a Power Apps per user license. The per user license is less expensive but only covers one app per user.