When user signs in to Office 365 portal and clicks on
OneDrive , gets a message
“Sorry for the delay. Your OneDrive is almost
ready.” Cause
Most common cause could be my site host is out of storage quota. Or user does not have permission to
create personal site. Resolution
- Go to SharePoint admin center
- Select my site host site collection. It should look like https://domain-my.sharepoint.com
- Click on Storage quota from ribbon and increase the quota and save it ,
If this is not applicable to the scenario move on to next steps:
- Go to SharePoint admin center > User profiles > Manage user permissions
- Ensure that either the affected user or Everyone except external users group is added there
- Under permissions ensure that “Create Personal Site (required for personal storage, newsfeed, and followed content)” is checked.

- Open Active Directory Users and Computer
- Expand your Domain Name / Organization name
- Right Click on the OU where you want the users to get created
- Click on Properties
- Click on Attribute Editor
- Look for Distinguish Name , copy the value
- Paste that in the path of the CSV file

UserPrincipleName : This can vary depending upon the email servers and even .local addresses can appended in there. It has to match your domain name standards.

After adding all the details in the CSV file , save that as bulkupload.csv and copy the file to the Active Directory Server. I am placing my file on the Desktop of the AD server.

Open Windows PowerShell in Elevated permissions (Run As Administrator) and run the following command after modifying the .csv file path.

If suppose you want to work on the GUID's in the registry and don't want to go through all the GUID's one by one, then you can try running the following command to get the list of all the Users with their profile GUID's , which make your life easier to troubleshoot.

Open Elevated PowerShell / Command prompt and run the following command: wmic useraccount get name,sid >C:\Profile.txt