In this session, we will dive into the capabilities of Microsoft Fabric Data Warehouse, revealing the details of its innovative features that are shaping the future of data warehousing. We will explore the architectural principles that revolutionize how Power BI interacts with Data Warehouse through Direct Lake, how you can query Fabric Lakehouses and other external data sources (Azure Data Lake, Amazon S3, Google GCP) without the need to ingest data, and how to use Python/Spark to access DW data using the open Delta Lake format.

Additionally, we will demonstrate how Fabric Data Warehouse seamlessly integrates with external databases such as Snowflake, Azure SQL DB, and Azure Cosmos Databases via mirroring, removing the need to craft complex ETL pipelines for data ingestion into the Data Warehouse.

We will also explain the latest enhancements, such as advanced string processing, time travel, table cloning, and query insights through live demonstrations. This demo-heavy session is tailored to equip data analysts, developers, architects, and decision makers with the knowledge that will elevate their data warehousing experience.