Overview

You can connect Dust to your Microsoft suite to enable access to the documents, spreadsheets, and presentations hosted in your Sharepoint drives. Only the content within the scope of the admin's Drive permissions will be available in Dust. The admin can granularly select the exact data they want to make available to Dust.

Dust doesn't take into account files with more than 1Mb of extracted text. Supported files include docx, pptx, and .txt files and PDFs (You can activate it at Spaces > Connected data and click on Manage Microsoft). xlsx files are parsed and each worksheet is available for table queries.

Setting up the Connection

To set up the Microsoft connection, follow these steps:

1. Acknowledge dust access to your Microsoft data

2. Login to your microsoft account and authorize permission. Only organizational accounts are supported, not personal ones.

   You can also use a Service Principal to login : fill in your tenant ID, client ID, and the secret to use. Your app will need the following permissions : Directory.Read.All,Files.Read.All,Sites.Read.All,User.Read

   

3. If you're not an admin on your Microsoft workspace, you may have to ask your administrator to consent Dust permissions for you. Once you clicked on "Request Admin consent", you will have to wait for the administrator to validate your request in their Azure admin panel :

   

4. Once authorized, you can select the data you want to synchronize with Dust :

Managing permissions

• You should use a dedicated microsoft account to manage permissions for Dust.
• The user need read permission on the files. All files and documents visible by the user will be available for Dust.

Refresh Rate

A synchronization happens every 5 minutes. All files created, modified or deleted during this period will not be updated immediately, but changes will be reflected only once a new synchronization is executed.

If a lot of files have been added or modified, the synchronization will take longer time.

Labels

Dust will sync the custom columns set on files when used in Sharepoint lists. They will be expose as labels and included in the document above the content itself.

Tags allow for keyword search and filtering while prepending them to the document content will expose them to the semantic search tool.

📘

Custom columns support was added Feb 14 2025

You may need update a document to have it re-synced.