cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Powerapp unable to write to Azure SQL after setting up Azure SQL Data Sync

I have a powerapp that has been writing to a Azure SQL database with no issues for sometime.  It is a basic SQL database with 5 DTU's and 2Gb which is plenty of resources for the app.  I set up a Azure SQL Data Sync, which backs up my Azure SQL tables to an on prem SQL Database.  The data sync works just fine.  The app however can no long write to the  SQL Database.  I get a Server Data Connection error.  Oddly, I can still read records in the Database.  I tried looking up the error with no help, I also made new connections in powerapps to the database with no change.   I then deleted the SQL data Sync and the app then worked correctly, read and write.  Anyone have any ideas?

 

Thanks

0 REPLIES 0

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

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

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (13,038)