Question for Chris Webb.. When using aggregates in Power BI with Databricks, should you put your dimensions in direct query, import or dual mode? Does it matter if the aggregates are defined using the relationships or groups? thanks
One thing which should be mentioned on the Databricks SQL Warehouse portion of the presentation is cost. Because the advised option of using a severless SQL warehouse is the most expensive one, costing 4-5x the amount of a classic Warehouse per DBU (around 0.9$). In addition, a medium-sized SQL Warehouse can consume up to 24 DBU/h/cluster.
Serverless SQL warehouse can help to achieve better TCO/performance when you also consider idle time (warehouse is up but not serving queries) and the need for quick scaling up and down when workloads get higher or lower.
This session is great briefing in terms of performance optimization about how PowerBI dealing with databricks components
Question for Chris Webb.. When using aggregates in Power BI with Databricks, should you put your dimensions in direct query, import or dual mode? Does it matter if the aggregates are defined using the relationships or groups? thanks
One thing which should be mentioned on the Databricks SQL Warehouse portion of the presentation is cost.
Because the advised option of using a severless SQL warehouse is the most expensive one, costing 4-5x the amount of a classic Warehouse per DBU (around 0.9$). In addition, a medium-sized SQL Warehouse can consume up to 24 DBU/h/cluster.
Serverless SQL warehouse can help to achieve better TCO/performance when you also consider idle time (warehouse is up but not serving queries) and the need for quick scaling up and down when workloads get higher or lower.