Hello @Brianben!
Classic SQL warehouses are better for cost-sensitive 24/7 workloads, stable query patterns, and older workflows that depend on traditional data warehouse setups or external Hive metastores. They also allow some manual configuration, giving more control over infrastructure.
On the other hand, serverless warehouses offer better performance, faster startup, and autoscaling. They are fully managed by Databricks, meaning less direct control.
For Power BI, serverless is generally the better choice due to quicker response times and better concurrency. However, a classic warehouse might be more cost-effective if you need a steady connection for continuous report updates.
For more insights, you can also check out this post: How to integrate Databricks and Power BI for real-time streaming analytics.
