Access web apps throttles and limits

Each Access Services application in Office 365 and SharePoint Online creates a corresponding SQL database that is subject to resource consumption limits. These limits are per database and apply whether using the web user interface or direct ODBC connection.

Important Microsoft no longer recommends creating and using Access web apps in SharePoint. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.

Access web app limits

Limit

Maximum value

Notes

Maximum query performance level

5 DTUs

This limit is calculated as a number of Database Transaction Units or DTUs, which is a blended measure of CPU, memory, and I/O (data and transaction log I/O).

How to avoid being throttled

If queries are being throttled, there may be some ways that you can reduce the amount of resources consumed without reducing the amount of data that your Access web app is accessing. Here are some general tips to reduce resource consumption:

Identify the top queries that can potentially be tuned for improved performance.