Copilot connectivity to Databricks - Error

Dear Selva N

Thanks for reaching out! Welcome to Microsoft Q&A. I'm Haien from Microsoft Q&A.

I understand you've successfully created and tested an agent to connect to Databricks in Copilot Studio. However, when you try to query a table using a prompt, you're receiving a "SystemError" with a specific error code, conversation ID, and timestamp. This type of error, especially with a generic "SystemError" code, indicates a failure at a fundamental level of the service, rather than a simple misconfiguration on your end

For your convenience, here is the best solution that I recommend you do in this situation:

Solution: Attempt account recovery via Microsoft website

• Open Databricks workspace > double-check that the user or service principal credentials used for the Copilot Studio connection have read access to the specific table you are trying to query > Verify that there are no network security group (NSG) rules or Databricks firewall settings that are blocking the connection during the data retrieval phase (which is different from the initial connection test).
• Check the Microsoft 365 Service Health Dashboard for any reported issues with Copilot or Databricks integration around the error time.
• Simplify the Prompt and re-try Query on Copilot

For additional information, please visit this website: Official Microsoft Copilot Studio documentation - Microsoft Copilot Studio | Microsoft Learn

Recommendation: Report to Feedback Hub

If none of the above solutions work, I strongly recommend that you contact Microsoft Support and submit feedback regarding the Copilot issue so they can verify your error.

• Open the Feedback Hub app > Click "Add new feedback." > Provide a detailed description of the issue, including when it started, what you've tried, and the result > Submit the feedback under the suitable category.

For additional information about how to send feedback to Microsoft about payments/purchase, please visit this article to know more: Send feedback to Microsoft with the Feedback Hub app - Microsoft Support

If you've already tried these steps and are still encountering issues, please reply to this thread with the requested details so we can investigate further and ensure your subscription is activated properly. Also, please keep me updated with anything new that you were try to each option.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

We appreciate your patience and look forward to resolving this quickly for you.

Warm regards,

Haien - MSFT | Microsoft Q&A Support Specialist 

Dear Selva N

Welcome to Microsoft Q&A. I'm Haien from Microsoft Q&A.

May I ask if you have tried my suggestions for your case? I hope you can keep me updated on your issue in the future.

Your satisfaction is Microsoft's priority.

If you've already tried these steps and are still encountering issues, please reply to this thread with the requested details so we can investigate further and ensure your subscription is activated properly. Also, please keep me updated with anything new that you were try to each option.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

We appreciate your patience and look forward to resolving this quickly for you.

Warm regards,

Haien - MSFT | Microsoft Q&A Support Specialist