I have an App with SQL as datasource. App was working fine till yesterday, today morning I see 'An error occured on the server'. I tried refreshing the datasources but still see the same issue. Can someone help me understand what the issue is?
Is the SQL server in Azure or On-premises? If its on-Premises check the Gateway to make sure its still communicating correctly.
Have you tried creating a new PowerApp quickly to test the connection? Does it also fail? Can you access the SQL database in Azure or with SQL Management Studio?
The only other suggestion I would have would be to remove the connection and recreate it. I know that can be a fair amount of work so its a last resort, but its the only other idea I have.
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications