talk-data.com

Join this session to learn about Lakehouse architecture in Microsoft Fabric. Microsoft Fabric is an end-to-end big data analytics platform that offers many capabilities including data integration, data engineering, data science, data lake, data warehouse, and many more, all in one unified SaaS model.

In this session, you will learn how to create a lakehouse in Microsoft Fabric, load it with sample data using Notebooks/Pipelines, and work with its built-in SQL Endpoint as well as its default Power BI dataset which uses a brand-new storage mode called Direct Lake.

Hybrid tables, a new addition to Power BI, are a game changer in that they provide the best of both worlds by allowing one table to have two storage modes at the same time!

Before the introduction of Hybrid tables, each table in Power BI could only have one storage mode: Import which loaded data entirely into Power BI’s memory or DirectQuery which left data in the back-end data source. When working with near real time requirements, Power BI developers had to use tables with DirectQuery; however, DirectQuery by itself could result in less than optimum query performance for large datasets and put a burden on the backend system. Hybrid tables combine the two storage modes and therefore provide improved query performance for historical data by loading them into memory (Import) and provide near real time capability for recent data (DirectQuery).

Join this session to learn about different table storage modes in Power BI including the newest Hybrid option and how to use it.