February 2026
Intermediate to advanced
390 pages
10h 23m
English
Content preview from Microsoft Fabric Analytics Engineer Associate Study Guide
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 6. Optimizing Enterprise-Scale Semantic Models
As your semantic model increases in size, its performance may become an issue. For smaller models, workarounds might work, but as your models grow, you’ll discover that optimization is not only nice to have—it’s crucial. A sluggish model can impact all the things you produce, including your Power BI reports, which must have quick-loading visuals and efficient refreshes so that end users will view them as workable. Over time, these performance challenges can create significant headaches for both the people working with the data and the end users.
This chapter will focus on helping you optimize performance by making smarter decisions on how to query, store, and refresh data. We’ll begin by identifying performance issues with DAX INFO.VIEW functions and the Power BI performance analyzer. Next, we’ll look at practical techniques for improving DAX performance, such as refining your measures. Then, we’ll look into Direct Lake, which is a storage mode that’s especially suitable for large semantic models, including those in enterprise-scale operations. Lastly, we’ll cover incremental refresh, which allows you to update only newly added data rather than reloading all data repeatedly. This becomes essential when you’re dealing with large semantic models with large amounts of frequently added data.
Understanding Performance Metrics in DAX Queries and Report Visuals
Slow performance can frustrate users and hurt adoption when building ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.