
The best they've come up in response the idea of a cut-down version of CDS we can use in Teams (Dataflex) which they're calling a relational database but I somewhat doubt we'll be able to create views from queries to even a fraction of the degree you can with SQL server.

There was massive pushback on this when they originally made the changes last year. Consumers should be either free or $1 or less. $40/user/month should be only for creators. I know MS is looking to hear from the community on licensing and pricing. $40 retail per user per month for premium connectors and it doesn't matter if you are a creator or consumer. Has anyone else come up with ways to not use premium connectors and still have apps that work with line of business applications?Īlso, has anyone else had conversations with Microsoft about the idiocy of their licensing model? One work around we have found is to replicate SQL data to SharePoint lists and use SharePoint as the data source for PowerApps.

We are working with our reseller and Microsoft to improve the situation, but at this point I may have to abandon the platform for 90% of our app needs.

The licensing model has changes a few times in the last year and we are looking at a $1.5M increase to our EES agreement which essentially doubles it. We had built several highly used apps on standard connectors that are now premium and our EES agreement is coming up. The SQL Azure connectors were some of these. Microsoft initially made certain connectors standard and then moved them to premium. We are in a situation that is causing us to re-think our use of PowerApps.
