Admins, makers, marketers, or analysts, automatically
Nov 30, 2022
-
Business value
The new Optimize ribbon in Power BI allows you to unlock big data scenarios with large models and DirectQuery.
Feature details
Working on a Power BI report in Power BI Desktop? Now, you can use the new Optimize ribbon, which includes pause visual queries and optimization presets. Pause visual queries allows you to add or remove field list items to a visual without the visual updating until you're ready. You can also refresh individual visuals without refreshing the whole page. It's available for import and DirectQuery reports, but DirectQuery report authors may find this feature most useful.
Another useful feature, especially for DirectQuery reports, is the ability to one-click apply Optimization presets. These presets are for either query reduction or interactivity, giving you a fast way to see which settings may work best for your reporting needs and to customize these settings even further.
Performance optimization, also known as performance tuning, involves making changes to the current state of the semantic model so that it runs more efficiently. Essentially, when your semantic model is optimized, it performs better.
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.