Semantic-link on Databricks

RicksDB — Sun, 16 Jun 2024 18:17:24 GMT

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!

Re: Semantic-link on Databricks

cassiebratt — Tue, 18 Jun 2024 04:27:19 GMT

@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.

Re: Semantic-link on Databricks

Palkers — Tue, 20 Aug 2024 17:52:44 GMT

I think partners connect give option to connect BI tools and their sementic models to DBX not DBX to SM,

in case you want to use models used for reports for AI/ML processing in dbx, you need to use something like semantic link to get data from SM directly including all calculations.

topic Re: Semantic-link on Databricks in Data Governance

Semantic-link on Databricks

Re: Semantic-link on Databricks

Re: Semantic-link on Databricks