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.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.