Azure SQL Database Pause state

[alunhughes]

Hi,

I have created a PowerApp with Azure SQL DB as the datasource. To save on Azure costs I have enabled the Auto-Pause after XX time of inactivity on SQL. When I then try to submit data from a form to SQL I'm presented with error messages that the SQL is unavailable. After this first attempt it works fine as SQL has returned to running from it's paused state.

Is there anything I can do (possibly on app load?) to connecto to the SQL database to wake it up prior to interacting with it?

Many thanks

[v-monli-msft · Accepted solution]

Hi @alunhughes ,

I think so far you cannot achieve this through PowerApps. If you need this feature, you could raise an idea in PowerApps Idea forum here:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Regards,

Mona