BI compatibility mode allows us to query Unity Catalog Metric Views from external BI tools. It allows Databricks to rewrite queries generated by tools like Power BI, ensuring complex metric view logic is executed correctly while appearing as standard regular tables (Metric Views) to the BI tools.
Microsoft has now removed the BI compatibility mode option from the Power BI connector. As a result, reports relying on this connector option have ceased to function.
You can
Advocate for Support - To request restored support for Databricks metric views in Power BI, vote and provide feedback on the Fabric Ideas forum.
Move To AI/BI - As an alternative to Power BI, use Databricks AI/BI dashboards, that works natively & seamlessly with metric views eliminating the need for translation layers or third-party compatibility toggles.
By moving to native AI/BI solutions, semantic layer remains performant, resilient and fully integrated with Unity Catalog.
