Skip to main content
Last updated on

Create a Databricks connection on Microsoft Power Platform

Preview

This feature is in Public Preview.

This page explains how to connect to Databricks from Microsoft Power Platform by creating a Databricks connection. You can use your Databricks data to create Power canvas apps, Power Automate flows, and Copilot Studio agents.

Before you begin​

Before you connect to Databricks from Power Platform, you must meet the following requirements:

  • You have a premium Power Apps license.
  • You have a Databricks account.
  • You have access to a SQL warehouse in Databricks.

Add a Databricks connection​

note

If you're using Copilot Studio, the Databricks connector must be defined using Power Apps or Power Automate. Then it can be used in Copilot Studio.

To add a Databricks connection, do the following:

  1. In Power Apps or Power Automate, from the sidebar, click Connections.

    If you don't see Connections on the sidebar, click More > Connections.

  2. In the upper-left corner, click + New connection.

  3. Using the search bar in the upper-right, search for "Databricks".

  4. Click the Databricks tile.

    Do not click the "Azure Databricks" tile.

  5. Enter your authentication information.

    To find your Databricks SQL warehouse and HTTP path connection details, see Get connection details for a Databricks compute resource.

  6. Click Create.

Add Databricks to a data policy​

By adding Databricks to a Business data policy, Databricks can't share data with connectors in other groups. This protects your data and prevents it from being shared with those who should not have access to it. For more information, see Manage data policies.

To add the Databricks connector to a Power Platform data policy:

  1. From any Power Platform application, click the settings gear in the upper-right side, and click Admin Center.
  2. From the sidebar, click Policies > Data Policies.
    • If you are using the new admin center, click Security > Data and Privacy > Data Policy.
  3. Click + New Policy or an existing policy.
  4. If creating a new policy, enter a name.
  5. Select an environment to add to your policy to and click + Add to policy above.
  6. Click Next.
  7. Search for and click the Databricks connector.
  8. Click Move to Business and click Next.
  9. Review your policy and click Create policy.

Limitations​

  • The Power Platform connector does not support government clouds.

Next steps​