Power Platform Community Forum Thread Details

Has anyone successfully added a SharePoint site (containing multiple PPT files) along with 4–5 Azure Databricks tables as knowledge sources for a Copilot Studio Agent?

I’m trying to enable users to query and get responses based on both of these knowledge sources.

I was manually able to:

1️⃣ Get the Server Hostname

2️⃣ Get the Server HTTP Path

3️⃣ Use OAuth as the authentication type

4️⃣ Get access to the Azure Resource Group and created a compute in my name

5️⃣ Gain access to one of the tables/catalogs in the workspace

However, I’m facing challenges connecting Azure Databricks as a knowledge source in Copilot Studio.

Has anyone encountered and resolved a similar issue? Any tips, Pre-requisites or permission i need to check what's causing the issue or best practices would be greatly appreciated.

Categories:

General topics

hello,

Very impressive work, my suggestion is little bit different since my expertise is elwhere, what i will try if had to do the same is using Azure AI Search since it has a connector ready to use and very easy to connect to copilot studio and i will try to folow tutorial like this one on how to connect both :

https://medium.com/@salah.uddin_75300/azure-ai-search-in-databricks-platform-68c99a514305

There are so many option and capabalities in Azure AI search that i will tend to use it like this :)

(i m not saying it's bad, it's just with my little knowledge on databricks i will do it this way ^^ - but there also more cost with AI Search, i m aware that's not the direct answer on how to use the inside connector)

If this can help you or solve the problem, please hit the answer button, it's important for the community and search engine