Before connecting Microsoft OneDrive to MSPbots
- Open a web browser and navigate to https://portal.azure.com.
- Log in using a Microsoft Global Admin account.
- Once logged in, you will see this screen with a search bar.
- Type Enterprise Applications on the search bar, then click Enterprise Applications on the search results window.
- Next, navigate to All Applications on the left.
- Go to the search bar in the middle of the screen and search for MSPbots Background Service.
- Click on the MSPbots Background Service which will open an Overview page.
- Scroll down on the left menu and click Permissions.
- Next, navigate to the search bar on the Permissions page and type Files.
- Click on the row with the Claim Value Files.Read.All and the Permission Read files in all site collections. This will show a flyout menu on the right.
When you can't find the permission Read files in all site collections, try clicking on the Grant admin consentfor "your company name" button first, then type Files to search.
You will also notice that the blue bar on the page now shows your company's name.
If a login prompt comes up, log in using your Global Admin account again.
- The Grant Permissions window will pop up and show that Read files in all site collections is now included in the Permissions. Click Accept.
Your OneDrive integration is successful when the confirmation of the permission being added appears on the top right.
Setting up and connecting Microsoft OneDrive to MSPbots
- Log in to the MSPbots dashboard as an administrator.
- Go to Integrations and search for OneDrive.
- After clicking the Sync button, the login interface of Microsoft Online will pop up, enter your username and password for authorization.
- A message saying that you have successfully linked OneDrive appears. Click the Save button.
- Test the connection.
Adding a CSV file for conversion into a dataset
After your successful integration of Microsoft OneDrive to MSPbots, you are now ready to import your data for dataset creation. For a guide on how to do this, read the article How to Add a CSV File for Conversion into a Dataset.
After the dataset is successfully generated, we will automatically sync the data when there are any updates to your CSV file.
- If you add or delete columns in the CSV file, we are unable to automatically sync the data and update your dataset. You can submit a request through our Help Center, and we will manually update your dataset, or you can re-add this CSV file to generate a new dataset.
The CSV files cannot contain any of the following:
- Blank rows
- Blank column headers
- Duplicate column headers
- Symbols in column headers
- Column headers that are more than 25 characters long
- Numbers with commas
Known issues
1. When you connect Microsoft OneDrive integration, it takes a long time and eventually displays "Whitelabel Error Page"

Possible cause
The account you used to log in to MSPbots is different from the one you authorized for MSPbots on OneDrive.
Troubleshooting
Check if the Microsoft OneDrive account authorized for MSPbots matches the one you used to log in to MSPbots.
- If they don't match, log in to MSPbots using the Microsoft OneDrive account you authorized for MSPbots.
- If they do match, try connecting Microsoft OneDrive integration three times. If the error still persists, submit a request through our Help Center.