Dataflows - Excel Document Builder for the Excel Workbook (XLSX) destination

The Excel Document Builder in Dataflow Gen2 provides a low-code experience for composing advanced Excel workbooks as the output of a dataflow. Generating formatted Excel documents is possible today through the advanced format of the Excel Workbook (XLSX) data destination, but it requires authoring the document structure directly in M. The Document Builder brings the same capability into a visual authoring dialog, enabling users to design multi-sheet workbooks without writing code.Users compose a workbook from a structure of sheets and parts, including Sheet Data, Table, Chart, and Range parts, and configure each part through a properties pane instead of M syntax. Charts can reference an existing table part by name rather than duplicating the underlying data, and built-in validation surfaces structural issues, such as an empty sheet or incompatible parts on the same sheet, before a refresh is consumed. On refresh, the dataflow renders the composed workbook and writes it to the configured destination.Key benefits and scenarios:* Design multi-sheet Excel workbooks with formatted tables and charts, without writing M code* Validate document structure during authoring, before the dataflow is refreshed* Deliver recurring, formatted Excel reports to business users on a refresh schedule, rather than raw data dumps* Preserve the code-first path: the Document Builder generates standard M, so document definitions remain versionable in source control and editable in the advanced editorBy adding a low-code authoring experience on top of the Excel Workbook data destination, Dataflow Gen2 makes advanced Excel document generation accessible to every dataflow author, not only those comfortable authoring M.