cancel
Showing results for 
Search instead for 
Did you mean: 
Data Governance
Join discussions on data governance practices, compliance, and security within the Databricks Community. Exchange strategies and insights to ensure data integrity and regulatory compliance.
cancel
Showing results for 
Search instead for 
Did you mean: 

Semantic-link on Databricks

RicksDB
Contributor II

Hello,

Is there any plan to support the equivalent of fabric semantic-link on Databricks? Essentially, having the ability to query PowerBi Dataset using SQL on interactive/jobs cluster and SQL warehouse (i.e a Unity Catalog federated source being PowerBI)

Thanks!

1 REPLY 1

cassiebratt
New Contributor II

@RicksDBMaryKayInTouch wrote:

Hello,

Is there any plan to support the equivalent of fabric semantic-link on Databricks? Essentially, having the ability to query PowerBi Dataset using SQL on interactive/jobs cluster and SQL warehouse (i.e a Unity Catalog federated source being PowerBI)

Thanks!


Hello,

No, Databricks itself doesn't currently offer a built-in functionality identical to Fabric Semantic Link for querying Power BI datasets directly. However, there are a couple of approaches to achieve a similar outcome:

Databricks Partner Connect: Databricks offers Partner Connect which allows integration with various semantic layer solutions. These solutions act as a bridge between Databricks and your Power BI datasets. You can explore partners listed in the Databricks documentation for semantic layer integration https://docs.databricks.com/en/partner-connect/semantic-layer.html.

Knowledge Graph Integration: Another approach involves using a knowledge graph platform like Stardog. This allows you to model complex relationships within your data, including data from Power BI. By integrating Stardog with Databricks, you can leverage SQL-like queries to explore the combined data landscape, including the semantic model from Power BI https://www.databricks.com/solutions/accelerators/rd-optimization-with-knowledge-graphs.

While these approaches differ slightly from Fabric Semantic Link, they offer functionalities to bridge the gap between Databricks and your Power BI datasets, enabling querying with SQL on Databricks clusters and warehouses.

I hope the solution may help you. 

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!