Microsoft changed PowerApp licensing on Office 365.  How can I get on premises SQL data for a PowerApp without using an On Premises Gateway?

Barney Evans
Barney Evans used Ask the Experts™

We are on Office 365. I built a simple PowerApp that displays our daily sales totals for our Management (8 Users). This App is getting the sales data from my SQL server using an On Premises Gateway. This has worked for almost a year. Recently Microsoft changed the licensing for PowerApps in Office 365 and wants us to upgrade to a Plan 2 license that costs $40 per user per month.

I'm trying to come up with a way to use this app without the On Premises Gateway. Any Suggestions?

Thank you.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Chinmay PatelChief Technology Ninja
Distinguished Expert 2018

Hi Barney,

May I know from where did you get this information? that you need PowerApps Plan 2?

Barney EvansIT System Administrator


Hi Chinmay,

After we started getting an error about licensing on the app, I did some searching. The information on licensing from Microsoft is confusing at best. According to what I can find, an On Premises Gateway is no longer a part of the powerapps licensing for Office 365 since January or February. Looking at my 365 licensing in the admin panel, I found 1000 Plan 2 powerapps trial licenses had be added to my companies account. If I assign Plan 2 trial license to the users of the app the license error goes away.

If I am wrong about how this is working I welcome any information anyone may have.

Jian An LimSolutions Architect
Top Expert 2016

it depends on how your application design
if your app is canvas then Plan 1
if your app is model driven then plan 2
Jian An LimSolutions Architect
Top Expert 2016

and yes, powerapp for office 365 cannot read onprem data minimum is plan 1
IT System Administrator
I'm now exporting the data from SQL to excel as a table and uploading to one-drive. I added a data connector to the excel file and it is working fairly well.

Thanks for the suggestions and information.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial