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
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (6,275)