'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Azure AD Failed to Insert User and Directory Object Quota Errors
Question details
The user is unable to bulk upload multiple users via a CSV file because the tenant has reached its directory object limit, resulting in a failed insertion error.
- Product
- Microsoft Azure Active Directory (Entra ID)
- Device & OS
- not provided
- Scenario
- Uploading a bulk user CSV file to create multiple new accounts in the Azure portal.
- Observed behavior
- The CSV upload process returns a 'Failed to insert user' error for remaining users because the tenant's Azure AD or Microsoft Entra directory-object quota has been exceeded.
Before proceeding, ensure you have global administrator or privileged role administrator credentials for your Microsoft Entra ID tenant to access support and manage deleted users.
Open a Technical Support Request to Increase Quota
The most direct way to resolve a hard limit on directory objects is to contact Microsoft Azure support to request a quota increase for your tenant.
By default, Azure AD (Microsoft Entra ID) enforces a strict quota on the total number of directory objects (such as users, groups, and applications) a tenant can hold. If you have reached this limit, you must submit a formal request to raise it.
Sign in to the Azure portal using an account with administrator permissions for your directory.
Use the search bar or the left-hand menu to find and select 'Help + support'.
Click on 'Create a support request'. Under the issue type, select 'Technical' and choose 'Microsoft Entra Directories and domains' as the service.
Explain that you are encountering 'Failed to insert user' errors due to the directory-object quota being exceeded during a CSV upload. Submit the ticket and wait for Azure support to increase your limit.
Permanently Delete Users and Groups to Free Up Space
If you recently deleted objects but still hit the quota limit, you need to clear them from the recycle bin, as soft-deleted items still count toward your total quota.
Prepare Your Azure Bulk Upload CSVs with WPS Office
While directory quotas are managed in Azure, preparing error-free bulk upload CSV files requires a reliable spreadsheet application. WPS Office is a lightweight, fully compatible, and free alternative to Microsoft Office that makes editing user data templates effortless.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your computer.
- 2. Open Your Bulk Upload Template: Launch WPS Spreadsheet and open the CSV template provided by Azure AD.
- 3. Edit and Save: Fill in the user data carefully to avoid formatting errors, then save the file in standard CSV format before uploading it to the Azure portal.
Frequently Asked Questions
What is the default directory object quota in Azure AD?
By default, an unverified Microsoft Entra ID (Azure AD) tenant has a limit of 50,000 directory objects. Once you verify at least one custom domain, this limit is automatically increased to 300,000 objects.
Why do I still get quota errors after deleting several users?
When you delete a user or group in Azure AD, it enters a 'soft-deleted' state for 30 days. Soft-deleted objects still count toward your total directory object quota. You must permanently delete them from the 'Deleted users' menu to immediately free up space.
Can I use WPS Office to edit the Azure AD bulk user upload CSV?
Yes, WPS Spreadsheet is fully compatible with CSV files. You can safely open, edit, and save the Azure AD bulk upload template in WPS Office without worrying about formatting corruption.
