Announcing the Azure Databricks connector in Power Platform

We are ecstatic to announce the public preview of the Azure Databricks Connector for Power Platform. This native connector is specifically for Power Apps, Power Automation, and Copilot Studio within Power Platform and enables seamless, single click connection.

With this connector, your organization can build data-driven, intelligent conversational experiences that leverage the full power of your data within Azure Databricks without any additional custom configuration or scripting – it's all fully built in! 

The Azure Databricks connector in power platform enables you to: 

• Maintain governance: All access controls for data you set up in Azure Databricks are maintained in Power Platform 

• Prevent data copy: Read and write to your data without data duplication 

• Secure your connection: Connect Azure Databricks to Power Platform using Microsoft Entra user-based OAuth or service principals 

• Have real time updates: Read and write data and see updates in Azure Databricks in near real time 

• Build agents with context: Build agents with Azure Databricks as grounding knowledge with all the context of your data

Instead of spending time copying or moving data and building custom connections which require additional manual maintenance, you can now seamlessly connect and focus on what matters – getting rich insights from your data – without worrying about security or governance. 

Let’s see how this connector can be beneficial across Power Apps, Power Automate, and Copilot Studio: 

Azure Databricks Connector for Power Apps – You can seamlessly connect to Azure Databricks from Power Apps to enable read/write access to your data directly within canvas apps enabling your organization to build data-driven experiences in real time. For example, our retail customers are using this connector to visualize different placements of items within the store and how they impact revenue. 

Azure Databricks Connector for Power Automate – You can execute SQL commands against your data within Azure Databricks with the rich context of your business use case. For example, one of our global retail customers is using automated workflows to track safety incidents, which plays a crucial role in keeping employees safe.  

Azure Databricks as a Knowledge Source in Copilot Studio – You can add Azure Databricks as a primary knowledge source for your agents, enabling them to understand, reason over, and respond to user prompts based on data from Azure Databricks. 

To get started, all you need to do in Power Apps or Power Automate is add a new connection – that's how simple it is!   

Check out our demo here and get started using our documentation today! This connector is available in all public cloud regions. You can also learn more about customer use cases in this blog. You can also review the connector reference here