# Understand why a workbook refresh preserves the reader's dropdown choice

> Why does returning a new default from a workbook parameter query not replace the user's current selection?

- Canonical URL: https://update.dsesecurity.com/updates/dse-20260909-374-understand-why-a-workbook-refresh-preserves-the-reader-s-dropdown-choice/
- Publisher: Detection Systems & Engineering (DSE Security)
- Author: DSE Security Editorial Team
- Published: 2026-09-10T00:25:42+00:00
- Modified: 2026-09-10T02:01:56+00:00
- Last reviewed by DSE: 2026-09-09
- Resource type: Explainer
- DSE priority: Information
- Topics: IT
- Reading time: 2 minutes

## What you need to know

Why does returning a new default from a workbook parameter query not replace the user's current selection?

## Potentially affected

Azure Monitor Workbooks using query-backed dropdown parameters.

## DSE recommendation

Test initial defaults, user selections and disappearing values as separate dropdown states.

## Article

## Source facts

A workbook dropdown’s default-selection field controls initial selection, not an override of later user choices. Once the user chooses values, a subsequent parameter query does not replace them with its new defaults. Default Items reruns the query and applies the defaults again. [Microsoft Learn](https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-dropdowns).

If refreshed results omit a previously selected value, that value is removed: selection becomes the intersection of the old selection and new results. The default-selection field is interpreted by its third-column position, and values such as false, zero, null or an empty string mean not selected. [Microsoft Learn](https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-dropdowns).

## Applicability

Review Azure Monitor Workbooks using query-backed dropdown parameters. This behavior concerns the parameter’s selected values, not the freshness of every chart or a pinned dashboard’s saved configuration.

## DSE recommendation

DSE recommends defining the intended reader experience for first load, refresh and return to defaults before modifying the parameter query. Do not treat a persisted user choice as evidence that the new query failed. If the returned item set changes, decide how downstream visuals should respond to a smaller or empty selection. Make the default-reset action discoverable in the workbook’s instructions.

## Verification

Start with no user selection and confirm the default. Choose another value, change the query’s defaults in an approved test, and refresh. Then remove one chosen item from the returned list and inspect the remaining selection. Finally use Default Items and confirm the newly queried default. Record these states alongside the query column order.

## Official references

[Microsoft Learn: Workbook dropdown parameters](https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-dropdowns).

## Primary reference

- Name: Azure Monitor workbook dropdown parameters - Azure Monitor | Microsoft Learn
- Authority: Microsoft Learn
- URL: https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-dropdowns
- Source publication date: Not stated by the source

## Citation and use

Preferred citation: “Understand why a workbook refresh preserves the reader's dropdown choice,” DSE Security, https://update.dsesecurity.com/updates/dse-20260909-374-understand-why-a-workbook-refresh-preserves-the-reader-s-dropdown-choice/
Publishing principles: https://update.dsesecurity.com/updates/dse-updates-editorial-methodology/
Usage and citation policy: https://update.dsesecurity.com/usage/
Copyright © 2026 Detection Systems & Engineering. All rights reserved.