Does Office 365 E3 include SQL Azure access

[WaltMarston]

As Access Web Apps are taken away, I need to know if my O365 E3 subscription gives me free access to SQL Azure for data storage I can create and then link to for PowerApps. Thanks for any suggestions. 

[hgowdy]

AFAIK No there is no free Azure SQL with E3 licences. You can connect OK to SQL in Azure but you have to pay for the DB.

Have a look at using CDS instead.  https://powerapps.microsoft.com/en-us/tutorials/pricing-billing-skus/  and https://powerapps.microsoft.com/en-us/pricing/

HCG

[WaltMarston]

Thanks. I'll explore CDS. However, my basic issue is that I have a utility set up in a desktop Access DB, runs a script to update data in SQL Azure DB (with Access Web App). With AWAs going away, I am replacing with PowerApp, but still want to run my utility script to update data in the back-end. Maybe I can do this with the data in a SP list. In any case, must have a dynamic link to data "table" 

[hgowdy]

Yes you can connect E3 to Azure SQL DB see -> https://powerapps.microsoft.com/en-us/tutorials/connection-azure-sqldatabase

Be carefull of using SP lists. Powerapps does not yet ( we live in hope) support sort/filter/lookup between lists using foreign keys.

[hgowdy]

I also found this that was just published -> https://powerapps.microsoft.com/en-us/tutorials/delegation-overview/

[WaltMarston · Accepted solution]

Thanks for all the suggestions. 

Basically, I've learned that (1) I can use SQL Azure but must pay extra for it, (2) for my offline utility, can link to SP list (but may have problem with multiple tables and lack of Primary Keys in some instances). For now, I'm just accessing one table, very simple app, so probably not a problem. 

I will keep in mind the "Delegation" issues. 

Thanks again. All I need for now. 

[WaltMarston]

Foreign keys, I mean.