Connecting BI and Partner Tools to Databricks Lakehouse
Overview
| Experience | In Person |
|---|---|
| Track | Data Warehousing |
| Industry | Enterprise Technology |
| Technologies | Data Marketplace, Databricks SQL, Unity Catalog |
| Skill Level | Beginner |
Did you know you can connect your favorite BI and collaboration tools directly to Databricks Lakehouse—without spinning up an extra data warehouse? In this session, we’ll explore how Databricks integrates seamlessly with tools like Excel, Google Sheets, Copilot Studio, Slack, Microsoft Teams, M365 Copilot, and more. You’ll see how these integrations empower your business users to tap into the full power of the Databricks Platform, including accessing Genie’s trusted insights directly into many of the applications they already use every day.
Session Speakers
Matt Holzapfel
/Sr Product Adoption Architect
Databricks
Toussaint Webb
/Sr. Product Manager
Databricks
Full Summary
Meeting business users where they work: Connecting the Databricks Platform to Excel, Sheets, Slack and Teams
Many analytics efforts slow down at the handoff to business tools. Most users spend their day in spreadsheets and collaboration apps, not in a data platform. The session explains how the Databricks Platform brings governed data and warehouse compute to every user without creating new data copies or bottlenecks.
FAQ
No. Both connectors offer point and click import by browsing catalogs, selecting a table or metric view, and applying filters. SQL remains available for advanced users, and Excel can run saved queries from the Databricks workspace.
Scheduled refresh is available in the Google Sheets connector and runs as a Lakeflow Jobs job that pushes results on a schedule. The Excel connector does not yet support scheduled refresh, with availability targeted by the end of the Databricks fiscal quarter.
Write back operates at the table level and fully respects Unity Catalog permissions. Users without appropriate rights cannot create new tables or overwrite existing ones.
During setup, admins connect the Genie app to a workspace and either scope it to a specific Genie Agent or allow it to search across the workspace using the ontology graph. Scoped setups are useful when the relevant context is known, while broader scopes let Genie discover the right assets.
No. Queries are executed directly against Databricks and results are returned to Power Apps, Power Automate, or Copilot Studio. Avoiding data copies keeps the lakehouse as the governed source of truth.