Enable native Power BI integration with Databricks Metric View

[dhaneswara]

Today, Power BI semantic models (datasets/DAX) work well when Power BI is the only BI tool. However, many organizations use Databricks as their lakehouse and need consistent, governed metrics across multiple BI tools, ML pipelines, and APIs. When the semantic layer lives only in Power BI:

• Logic is duplicated across datasets and tools

• Governance/security (RLS/CLS, masking) is fragmented

• Schema changes in Databricks break reports

• ML/AI pipelines cannot reuse business logic from Power BI models

Proposal: Enable native Power BI integration with Databricks Metric View

[onno101]

+1 I am working with 4 companies that are requesting this feature

[x2ad3ggs]

Please add this! It would really impact our organization.

[isaacr]

This feature actually helps my customer to adopt Power BI as they look to separate the semantic layer from the reporting layer. Tableau is already planning for integration.

[laurentprat]

Shift left => Semantic should be globally defined

[laurentprat]

Shift left => Semantic should be globally defined

[muchinski]

I've been listening from customers that they plan to move out of Power BI, if a good integration with Metric Views is not in place soon...

[JN_UK]

We're working with clients who are looking at Sigma because it doesn't have this limitation ✔️

[bez]

this would really help my organisation adopt PowerBI as part of Fabric. Significant investment has been made in Unity Catalog to date, and we would want the benefits of leveraging this to drive PBI as a first-class viz tool.

[prashsub_on]

Right now, I am able to push from Unity Catalog straight to Power BI a relational model if I define the Primary and Foreign Keys correctly - but the metric views don't go through as measures. It would be awesome if this is integrated, so we can continue using the UC to Power BI integration and avoid duplicating measures across multiple semantic models.

[mikelombardi35]

Totally agree that shift left on metric definitions and keeping it as close to the data as possible in unified semantic layer. Most orgs use multiple reporting tools, flexibility to leverage the same definition regardless of tool is paramount. Companies like dbt already embrace this and provide multiple tools to connect to a common semantic layer.