Get report (raw) data in Excel from the request page

Important

This content is archived and is not being updated. For the latest documentation, go to New and Planned for Dynamics 365 Business Central. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Users by admins, makers, or analysts Jun 23, 2021 Jul 9, 2021

Business value

Reports provide a view of structured business data, but often you want access to the data behind the report for analysis and fact finding. The data is the raw dataset from the report, filtered based on your selection in the request page. The data includes all calculations and aggregations in the report, but it is presented without any layouts on top. It's ready for your analysis or a user-defined presentation in Excel.

Feature details

From the Send to menu on the request page, users can now choose Microsoft Excel Document (data only).

When you choose this option, Business Central generates the report without a layout and presents the raw dataset in an Excel file.

See also

Working with Reports, Batch Jobs, and XMLports (docs)