Thursday 12:40 PM - 1:50 PM · Room 344

Power BI Storage Modes: The Ultimate Showdown

Philip Seamark

Microsoft Fabric CAT team

Power BI offers three different storage modes for data: Direct Query, Import and Direct Lake. Each of them has its own advantages and disadvantages, depending on the scenario and the requirements. But which one is the best overall? How do they compare in terms of performance, scalability, flexibility and ease of use?

In this session, we will put the three storage modes to the test in a series of challenges inspired by the Olympic Pentathlon. We will use real-world data sets and scenarios to measure how each storage mode handles different aspects of data analysis and visualization. We will also share some best practices and tips on how to choose the right storage mode for your project.

By the end of this session, you will have a better understanding of the strengths and weaknesses of each storage mode, and you will be able to decide which one deserves the gold medal in your Power BI dashboard.