โ08-10-2022 03:54 PM
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!
โ12-08-2022 08:36 PM
@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?
โ12-08-2022 09:39 PM
Thanks for sharing @Taha Hussainโ
โ12-08-2022 09:46 PM
thanks for the documentation @Taha Hussainโ
โ12-09-2022 05:00 AM
Thanks for the documentation @Taha Hussainโ this is awesome.
โ12-09-2022 05:34 AM
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
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโt want to miss the chance to attend and share knowledge.
If there isnโt a group near you, start one and help create a community that brings people together.
Request a New Group