Azure Open AI with Own Data using Cognitive Search & Sharepoint with Microsoft Groups and Multiple sites support

Question

Dear Team,

We are keen to explore the integration of Azure OpenAI with Cognitive Search and SharePoint, utilizing the SharePoint Indexer(Preview) feature.

Currently, we are encountering a couple of challenges related to SharePoint authorization, which we have set up using Microsoft Groups to enforce role-based access control over our document repository.

Within the SharePoint Indexer(Preview), we are unable to identify a straightforward method for implementing role-based access control for our documents, aligning with the access permissions of the logged-in user.

Additionally, we manage a substantial SharePoint environment consisting of over 15,000 SharePoint sites, each containing numerous folders and organized documents. However, when configuring a data source in Cognitive Search, we observe that we can only specify a single SharePoint site as demonstrated below:

{
    "name": "sharepoint-datasource",
    "type": "sharepoint",
    "credentials": {
        "connectionString": "{{connectionString}}"
    },
    "container": {
        "name": "useQuery",
        "query": "includeLibrary=https://tenant.sharepoint.com/sites/sitename/Default Document"
    }
}

We would greatly appreciate your guidance on potential workarounds for these two limitations we are currently facing. Moreover, we are curious to learn if your team is actively addressing these challenges and if there is a tentative plan for transitioning the SharePoint Indexer from its current preview state to a globally available feature.

Thank you for your assistance and insights.

Answer 1

@Kenneth Karlsen Thanks for the question, It's on the roadmap to support the sharepoint officially and move to GA. you can also use the BA Insights connector if you are looking for a prod quality, supported SLA'ed solution.

https://www.linkedin.com/pulse/chatgpt-enterprise-data-azure-openai-cognitive-search-leo-wang-1c/