cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Does Office 365 E3 include SQL Azure access

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Regular Visitor

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. 

View solution in original post

6 REPLIES 6
Advocate IV
Advocate IV

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

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" 

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.

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

Regular Visitor

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. 

View solution in original post

Foreign keys, I mean. 

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (70,058)