{ "api_version": "1", "kind": "dse_post", "self": "https://update.dsesecurity.com/api/v1/posts/dse-20260909-244-avoid-a-hidden-merge-dependency-that-stops-a-workbook-s-downstream-result/", "item": { "id": "https://update.dsesecurity.com/updates/dse-20260909-244-avoid-a-hidden-merge-dependency-that-stops-a-workbook-s-downstream-result/", "slug": "dse-20260909-244-avoid-a-hidden-merge-dependency-that-stops-a-workbook-s-downstream-result", "url": "https://update.dsesecurity.com/updates/dse-20260909-244-avoid-a-hidden-merge-dependency-that-stops-a-workbook-s-downstream-result/", "alternate_urls": { "markdown": "https://update.dsesecurity.com/updates/dse-20260909-244-avoid-a-hidden-merge-dependency-that-stops-a-workbook-s-downstream-result.md", "json": "https://update.dsesecurity.com/api/v1/posts/dse-20260909-244-avoid-a-hidden-merge-dependency-that-stops-a-workbook-s-downstream-result/" }, "title": "Avoid a hidden merge dependency that stops a workbook's downstream result", "summary": "Will a hidden workbook merge step run when another merge step depends on it?", "format": { "slug": "guide", "name": "Guide" }, "priority": { "slug": "info", "name": "Information" }, "featured": false, "image": { "theme": "managed-it", "label": "Managed IT operations", "alt": "A controlled technology lifecycle progressing from assessment to approved production.", "card_url": "https://update.dsesecurity.com/assets/editorial/managed-it-card.webp?v=1.8.20", "hero_url": "https://update.dsesecurity.com/assets/editorial/managed-it-hero.webp?v=1.8.20", "social_url": "https://update.dsesecurity.com/assets/editorial/managed-it-social-v2.jpg?v=1.8.20", "width": 2400, "height": 1350 }, "topics": [ { "slug": "it", "name": "IT", "url": "https://update.dsesecurity.com/topic/it/" } ], "author": { "name": "DSE Security Editorial Team", "url": "https://update.dsesecurity.com/#editorial-team", "type": "Organization" }, "publisher": { "name": "Detection Systems & Engineering", "url": "https://dsesecurity.com/" }, "published_at": "2026-09-10T00:27:52+00:00", "modified_at": "2026-09-10T01:20:46+00:00", "reviewed_on": "2026-09-09", "reading_minutes": 2, "word_count": 238, "potentially_affected": "Azure Workbooks using a merge data source that references another hidden merge step.", "dse_recommendation": "Flatten a chained merge where practical and test visibility-dependent execution before publishing the workbook.", "primary_source": { "name": "Azure Workbooks data sources - Azure Monitor | Microsoft Learn", "url": "https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-data-sources", "published_on": null, "authority": "Microsoft Learn" }, "publishing_principles": "https://update.dsesecurity.com/updates/dse-updates-editorial-methodology/", "usage_info": "https://update.dsesecurity.com/usage/", "copyright_notice": "Copyright © 2026 Detection Systems & Engineering. All rights reserved.", "content_html": "

Source facts

\n

Workbooks can run hidden query and metric steps when a merge references them, but hidden steps that themselves use the merge data source do not run. A downstream merge referencing such a hidden merge waits until that step becomes visible. Microsoft notes that one merge can combine several sources, so chaining merge steps is rarely necessary. Microsoft Learn.

\n

Applicability

\n

Use this execution check when a workbook result disappears after an author hides an intermediate step. Distinguish an ordinary hidden source query from a hidden merge; their treatment is not interchangeable.

\n

DSE recommendation

\n

Flatten a chained merge where practical and test visibility-dependent execution before publishing the workbook. Sketch which source steps feed the final result and identify any intermediate merge that is hidden by default or by a parameter choice. Keep presentation cleanup separate from changes to the data dependency structure. Preserve the original workbook while revising the chain so expected results can be compared.

\n

Verification

\n

Run the workbook with the intermediate merge visible and record the downstream result. Repeat with the intended hidden state and check whether the dependency still executes. After restructuring, compare the final rows and values with the known visible-step result across relevant parameter choices. Do not treat a newly empty final grid as evidence that the monitored environment has no matching data until this execution dependency has been excluded.

\n

Official references

\n

Microsoft Learn: Workbook data sources and merge behavior. Source reviewed September 9, 2026.

", "content_text": "Source facts\nWorkbooks can run hidden query and metric steps when a merge references them, but hidden steps that themselves use the merge data source do not run. A downstream merge referencing such a hidden merge waits until that step becomes visible. Microsoft notes that one merge can combine several sources, so chaining merge steps is rarely necessary. Microsoft Learn.\nApplicability\nUse this execution check when a workbook result disappears after an author hides an intermediate step. Distinguish an ordinary hidden source query from a hidden merge; their treatment is not interchangeable.\nDSE recommendation\nFlatten a chained merge where practical and test visibility-dependent execution before publishing the workbook. Sketch which source steps feed the final result and identify any intermediate merge that is hidden by default or by a parameter choice. Keep presentation cleanup separate from changes to the data dependency structure. Preserve the original workbook while revising the chain so expected results can be compared.\nVerification\nRun the workbook with the intermediate merge visible and record the downstream result. Repeat with the intended hidden state and check whether the dependency still executes. After restructuring, compare the final rows and values with the known visible-step result across relevant parameter choices. Do not treat a newly empty final grid as evidence that the monitored environment has no matching data until this execution dependency has been excluded.\nOfficial references\nMicrosoft Learn: Workbook data sources and merge behavior. Source reviewed September 9, 2026.", "content_markdown": "## Source facts\n\nWorkbooks can run hidden query and metric steps when a merge references them, but hidden steps that themselves use the merge data source do not run. A downstream merge referencing such a hidden merge waits until that step becomes visible. Microsoft notes that one merge can combine several sources, so chaining merge steps is rarely necessary. [Microsoft Learn](https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-data-sources).\n\n## Applicability\n\nUse this execution check when a workbook result disappears after an author hides an intermediate step. Distinguish an ordinary hidden source query from a hidden merge; their treatment is not interchangeable.\n\n## DSE recommendation\n\nFlatten a chained merge where practical and test visibility-dependent execution before publishing the workbook. Sketch which source steps feed the final result and identify any intermediate merge that is hidden by default or by a parameter choice. Keep presentation cleanup separate from changes to the data dependency structure. Preserve the original workbook while revising the chain so expected results can be compared.\n\n## Verification\n\nRun the workbook with the intermediate merge visible and record the downstream result. Repeat with the intended hidden state and check whether the dependency still executes. After restructuring, compare the final rows and values with the known visible-step result across relevant parameter choices. Do not treat a newly empty final grid as evidence that the monitored environment has no matching data until this execution dependency has been excluded.\n\n## Official references\n\n[Microsoft Learn: Workbook data sources and merge behavior](https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-data-sources). Source reviewed September 9, 2026." }, "json_ld": { "@context": "https://schema.org", "@graph": [ { "@type": "Organization", "@id": "https://dsesecurity.com/#organization", "name": "Detection Systems & Engineering", "alternateName": "DSE Security", "url": "https://dsesecurity.com/", "logo": { "@type": "ImageObject", "url": "https://update.dsesecurity.com/assets/dse-logo-20260812.png?v=1.8.20" } }, { "@type": "Organization", "@id": "https://update.dsesecurity.com/#editorial-team", "name": "DSE Security Editorial Team", "url": "https://update.dsesecurity.com/", "parentOrganization": { "@id": "https://dsesecurity.com/#organization" } }, { "@type": "WebSite", "@id": "https://update.dsesecurity.com/#website", "name": "DSE Updates", "alternateName": "DSE Security Knowledge Hub", "url": "https://update.dsesecurity.com/", "inLanguage": "en-US", "publisher": { "@id": "https://dsesecurity.com/#organization" }, "potentialAction": { "@type": "SearchAction", "target": { "@type": "EntryPoint", "urlTemplate": "https://update.dsesecurity.com/?q={search_term_string}" }, "query-input": "required name=search_term_string" } }, { "@type": "WebPage", "@id": "https://update.dsesecurity.com/updates/dse-20260909-244-avoid-a-hidden-merge-dependency-that-stops-a-workbook-s-downstream-result/", "url": "https://update.dsesecurity.com/updates/dse-20260909-244-avoid-a-hidden-merge-dependency-that-stops-a-workbook-s-downstream-result/", "isPartOf": { "@id": "https://update.dsesecurity.com/#website" }, "lastReviewed": "2026-09-09" }, { "@type": "BreadcrumbList", "@id": "https://update.dsesecurity.com/updates/dse-20260909-244-avoid-a-hidden-merge-dependency-that-stops-a-workbook-s-downstream-result/#breadcrumbs", "itemListElement": [ { "@type": "ListItem", "position": 1, "name": "DSE Updates", "item": "https://update.dsesecurity.com/" }, { "@type": "ListItem", "position": 2, "name": "Avoid a hidden merge dependency that stops a workbook's downstream result", "item": "https://update.dsesecurity.com/updates/dse-20260909-244-avoid-a-hidden-merge-dependency-that-stops-a-workbook-s-downstream-result/" } ] }, { "@type": [ "Article", "TechArticle" ], "@id": "https://update.dsesecurity.com/updates/dse-20260909-244-avoid-a-hidden-merge-dependency-that-stops-a-workbook-s-downstream-result/#article", "identifier": "https://update.dsesecurity.com/updates/dse-20260909-244-avoid-a-hidden-merge-dependency-that-stops-a-workbook-s-downstream-result/", "url": "https://update.dsesecurity.com/updates/dse-20260909-244-avoid-a-hidden-merge-dependency-that-stops-a-workbook-s-downstream-result/", "headline": "Avoid a hidden merge dependency that stops a workbook's downstream result", "description": "Will a hidden workbook merge step run when another merge step depends on it?", "abstract": "Will a hidden workbook merge step run when another merge step depends on it?", "articleBody": "Source facts\nWorkbooks can run hidden query and metric steps when a merge references them, but hidden steps that themselves use the merge data source do not run. A downstream merge referencing such a hidden merge waits until that step becomes visible. Microsoft notes that one merge can combine several sources, so chaining merge steps is rarely necessary. Microsoft Learn.\nApplicability\nUse this execution check when a workbook result disappears after an author hides an intermediate step. Distinguish an ordinary hidden source query from a hidden merge; their treatment is not interchangeable.\nDSE recommendation\nFlatten a chained merge where practical and test visibility-dependent execution before publishing the workbook. Sketch which source steps feed the final result and identify any intermediate merge that is hidden by default or by a parameter choice. Keep presentation cleanup separate from changes to the data dependency structure. Preserve the original workbook while revising the chain so expected results can be compared.\nVerification\nRun the workbook with the intermediate merge visible and record the downstream result. Repeat with the intended hidden state and check whether the dependency still executes. After restructuring, compare the final rows and values with the known visible-step result across relevant parameter choices. Do not treat a newly empty final grid as evidence that the monitored environment has no matching data until this execution dependency has been excluded.\nOfficial references\nMicrosoft Learn: Workbook data sources and merge behavior. Source reviewed September 9, 2026.", "datePublished": "2026-09-10T00:27:52+00:00", "dateModified": "2026-09-10T01:20:46+00:00", "mainEntityOfPage": { "@id": "https://update.dsesecurity.com/updates/dse-20260909-244-avoid-a-hidden-merge-dependency-that-stops-a-workbook-s-downstream-result/" }, "inLanguage": "en-US", "isAccessibleForFree": true, "author": { "@type": "Organization", "name": "DSE Security Editorial Team", "url": "https://update.dsesecurity.com/#editorial-team" }, "publisher": { "@id": "https://dsesecurity.com/#organization" }, "image": { "@type": "ImageObject", "@id": "https://update.dsesecurity.com/updates/dse-20260909-244-avoid-a-hidden-merge-dependency-that-stops-a-workbook-s-downstream-result/#primaryimage", "url": "https://update.dsesecurity.com/assets/editorial/managed-it-social-v2.jpg?v=1.8.20", "contentUrl": "https://update.dsesecurity.com/assets/editorial/managed-it-social-v2.jpg?v=1.8.20", "width": 1200, "height": 630, "caption": "Avoid a hidden merge dependency that stops a workbook's downstream result" }, "articleSection": [ "IT" ], "keywords": [ "IT", "Guide", "Information priority" ], "genre": "Guide", "about": [ { "@type": "Thing", "name": "IT", "url": "https://update.dsesecurity.com/topic/it/" } ], "wordCount": 238, "timeRequired": "PT2M", "publishingPrinciples": "https://update.dsesecurity.com/updates/dse-updates-editorial-methodology/", "usageInfo": "https://update.dsesecurity.com/usage/", "copyrightHolder": { "@id": "https://dsesecurity.com/#organization" }, "copyrightNotice": "Copyright © 2026 Detection Systems & Engineering. All rights reserved.", "citation": { "@type": "CreativeWork", "name": "Azure Workbooks data sources - Azure Monitor | Microsoft Learn", "url": "https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-data-sources" } } ] } }