BI compatibility mode for metric views in Power BI is now available in Beta.
BI compatibility mode for metric views in Power BI is now available in Beta. You can query Databricks metric views in Power BI using standard SQL aggregation functions by enabling BI compatibility mode when creating a connection. It automatically rewrites aggregate functions to use the correct measure definitions.
When you query a materialized metric view, the query optimizer automatically routes the query to a suitable materialization for faster performance, or falls back to the source data when no suitable materialization is available.
BI compatibility mode for metric views in Power BI is now available in Beta. You can query Databricks metric views in Power BI using standard SQL aggregation functions by enabling BI compatibility mode when creating a connection.
Read the full documentation ↗