Unanswered

License question

(0) Share

Report

Posted on by Community Power Pla...

Hello
I need some understanding on a particular license

Our technicians have an F1 license which I know does not allow custom connections or write back capability. However included in our package we have roughly 10k unused licenses that have the title “powerapps and logic flows”

Does anyone know what comes with that license? I have read and re read the license documentation and can’t seem to find information on this one in particular.

I need to be able to write data back to on prim SQL server and I am hoping that this license gives that capability. Also hoping to be able to call XMLA Endpoint in PBI premium.

Any help would be greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Anonymous

I think the entry you're seeing there refers to the number of Flow runs.

With Office 365 (F1), you're entitiled to 2k Flow runs per license as shown in link below. Flow runs are aggregated per organisation so with 5 F1 license, that would account for 10k license.

https://flow.microsoft.com/en-us/pricing/

I'm certain that the entry you see doesn't give you access to on-premises SQL server, or custom connectors. For that, you'll need either a P1 or P2 license.

It's also worth noting that all of this changes in October. From that point, you'll need to license on a per user or per app basis to SQL and custom connectors, and there are more details in this blog post.

https://powerapps.microsoft.com/en-us/blog/new-licensing-options-for-powerapps-and-flow/

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I think I got ya. So Would I be able to connect to the XMLA endpoints from power bi to display metrics since Azure SQL data warehouse is standard? Or would I have to pull that data into SQL and then call it from there which would not work because of our licenses?

Sry still a little unclear on that one.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report
F1 licenses include PowerApps and Flow licenses. The special limitation on those licenses is the following:

PowerApps is limited to consumption only (no publishing or sharing).

Flow is limited to consumption only and runs are limited to 750 per user per month.

AS described in this official article https://docs.microsoft.com/en-us/office365/servicedescriptions/office-365-platform-service-description/office-365-platform-service-description

Other normal restrictions apply to premium services like custom connectors and on-premises gateways. But there is no limitation on read/write access to data. F1 license users can't create or share apps, but they can run apps and use their full functionality.

The problem in your scenario is that the SQL server is on-premises. Although the SQL connector is standard and available for use by F1 licensed users, you will need an on-premises gateway to access the SQL server. Gateways are an premium feature and require either a P1 or P2 license. The 10,000 existing licenses that you have won't cover this functionality either, since they are undoubtedly standard licenses.

However, an Azure based SQL server can be accessed without a gateway. So if the database in question where moved to Azure then the F1 users could access it with their existing F1 license. The only thing that would be needed would be a regular licensed user to create and share the app with them.

Was this reply helpful? Yes No
NarobixLives 3 on at

Like (0)

Report

Hi Pstork, on the off chance you're able to answer with current information, the link you provided now details that F1 does not provide Power Automate or Power Apps access, so wondering if there is anything to substantiate that F1 can interact with flows and power apps without any additional licenses being purchased.

Cheers,

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

Sorry, that is evidently a new change. As I mentioned in the past F1 licenses could run Power Apps or Power Automate flows, but they couldn't edit them. Now it appears that an F3 license is needed for F class licenses to use Power Apps. The post with the link was from 2019. At that point in time F1 licenses were able to use the Power Platform.

Was this reply helpful? Yes No