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 the News & Announcements to learn more.
Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.