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.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks