topic Databricks Tables in Excel in Data Engineering

Databricks Tables in Excel

haydenLiQ — Thu, 17 Oct 2024 05:32:14 GMT

I attended the Databricks World Tour in 2023 (not the most recent one) where I remember there was mention of a feature in development that was an add-in (or similar) for Excel that would allow for native connection and importation of a Databricks table into an Excel workbook.

I can't remember what this was called and from what I can see, it has not been implemented yet. Does anyone know if Im just missing it somewhere, or when it may be available?

I understand that you can connect to Databricks from Excel using the ODBC driver. But I am hoping for a solution that is more streamlined and easier to implement for non-technical users.

Re: Databricks Tables in Excel

szymon_dybczak — Thu, 17 Oct 2024 08:43:54 GMT

Hi @haydenLiQ ,

Maybe it was something similar to below?

https://marketplace.databricks.com/details/a3633e2c-883c-4487-92f5-67ab50195259/ExponamConnect_Access-Data-in-Excel

Re: Databricks Tables in Excel

Panda — Thu, 17 Oct 2024 09:49:30 GMT

@haydenLiQ -
Power BI has native support for Databricks connections via the Azure Databricks connector. You can pull data from Databricks into Power BI, create datasets, and then use Power BI’s Excel integration to export these datasets into Excel.
Connect Power BI to Azure Databricks

May be one of the non Technical User Solution 🤔