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