Power BI on Databricks Best Practices
Вставка
- Опубліковано 27 сер 2024
- Watch this exclusive webinar (originally streamed live on March 14), where Chris Webb, Principal Program Manager at Microsoft, and Denny Lee, Sr. Staff Developer Advocate at Databricks, will explore the synergy between Databricks and Power BI for big data processing and visualization.
Learn from the experts as they share best practices and optimization tips to enhance your data analytics workflow. Facilitated by Liping Huang and Marius Pang, this event promises invaluable insights into maximizing the potential of your data infrastructure and elevating your data strategy! - Наука та технологія
This session is great briefing in terms of performance optimization about how PowerBI dealing with databricks components
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.
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