Every so often, we seem to get the dreaded 'Database Request Limit Reached' error on an Azure SQL DB. After some research, I've found that it may be caused by the SQL connection not closing once the connection is not needed anymore.
Of course of the solutions would be to increase the request limit, but before that happens, is there any way in PowerApps to 'close' a connection after the user navigates back to a different screen for example. Something similar to C# when we put a conn.Close() in a 'finally'clause.
Thanks.
User | Count |
---|---|
141 | |
136 | |
77 | |
75 | |
69 |
User | Count |
---|---|
226 | |
186 | |
68 | |
63 | |
57 |