Optimize ribbon in Power BI Desktop

Important

This content is archived and is not being updated. For the latest documentation, go to What's new in Power BI?. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
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.

Optimize settings in the Optimize ribbon.

Pause visuals in the Optimize ribbon.

See also

Optimize ribbon in Power BI Desktop Preview (docs)