topic Re: Connect a BI Tool: How do I access my lakehouse data from my BI tool? in Data Engineering

Connect a BI Tool: How do I access my lakehouse data from my BI tool?

Taha_Hussain — Wed, 10 Aug 2022 22:54:24 GMT

You can find a rich ecosystem of tools that allow you to work with all your data in-place and deliver real-time business insights faster.

This post will help you connect your existing tools like dbt, Fivetran, PowerBI, Tableau or SAP to ingest, transform, query and visualize the most recent and complete data from your lakehouse, without having to move it into a separate data warehouse.

Note: To learn more about creating queries and visualizations that feed into your BI tool, review this step-by-step guide.

To connect your data with a BI tool, review this documentation or follow these steps:

1. Make sure your Databricks account, workspace and the signed-in user all meet the requirements for Partner Connect

2. Go to the bottom of the sidebar and click Partner Connect

3. Click the tile for the partner that you want to connect your workspace with. If the tile has a checkmark icon, stop here, as your workspace is already connected. Otherwise, follow the on-screen directions to finish creating the connection.

Note: Power BI Desktop, Tableau Desktop and other locally-installed applications do not display a checkmark icon, even after you connect your workspace to them

Note: For the fastest connections, we often recommend using FiveTran for data ingestion

You are now ready to discover new business insights with the most complete and freshest data.

Learn more:

• Video Series on integrating tools through Partner Connect

• Documentation on queries and visualizations

• Databricks Academy Introduction to creating queries and visualizations

• Databricks SQL demo highlighting SQL query editor, built-in data visualization tools, and flexible dashboarding and alerting capabilities

• Feel free to contact us

Drop your questions, feedback and tips below!

Re: Connect a BI Tool: How do I access my lakehouse data from my BI tool?

KKo — Fri, 09 Dec 2022 04:36:55 GMT

@Taha Hussain I connect to Databricks table using below approach from PBI desktop.

a) What is the benefit of your approach vs the approach I mentioned?

b) The performance of the report is very slow when I use direct query to the Databricks table, what could be the reason here? On the other hand doing the same thing from other RDMS (Azure sql, synapse db) the refresh is faster.

c) I just use data science and data engineering component of Databricks. Would the refresh of report would be faster if I use Databricks SQL?

Re: Connect a BI Tool: How do I access my lakehouse data from my BI tool?

Ajay-Pandey — Fri, 09 Dec 2022 05:39:12 GMT

Thanks for sharing @Taha Hussain

Re: Connect a BI Tool: How do I access my lakehouse data from my BI tool?

Rishabh-Pandey — Fri, 09 Dec 2022 05:46:05 GMT

thanks for the documentation @Taha Hussain

Re: Connect a BI Tool: How do I access my lakehouse data from my BI tool?

tunstila — Fri, 09 Dec 2022 13:00:52 GMT

Thanks for the documentation @Taha Hussain this is awesome.

Re: Connect a BI Tool: How do I access my lakehouse data from my BI tool?

Axserv — Fri, 09 Dec 2022 13:34:49 GMT

Hello Taha, here is a fairly recent video provided by Databricks on conncecting Power BI :

Demo Video: Connect to Power BI Desktop from Databricks - YouTube