Others

Can Jet Reports Extract All Dynamics 365 Business Central Data?

John WilsonJohn Wilson Nov 3, 2026 868 views

Question details

The user is inquiring if the Jet Reports add-in can extract all data from Microsoft Dynamics 365 Business Central or Navision, specifically targeting information stored in system objects rather than standard tables.

Can Jet Reports Extract All Dynamics 365 Business Central Data?
Product
Microsoft Dynamics 365
Device & OS
not provided
Scenario
Attempting to pull comprehensive business data, including non-table data and system objects, from Business Central into a reporting spreadsheet using Jet Reports.
Observed behavior
The user is unsure about the scope and limitations of Jet Reports regarding the extraction of complex system object data in Dynamics 365.
Before you start

Verify your current user access levels in Microsoft Dynamics 365 Business Central and ensure your Jet Reports connector is updated, as extracting non-standard data heavily relies on appropriate API permissions.

Solution 1Recommended

Consult the Microsoft Dynamics 365 Community

Since extracting data from system objects involves specific configurations and permissions outside general support, the most effective solution is to engage with Dynamics specialists.

Jet Reports typically functions smoothly with standard, exposed Business Central data sources. However, accessing system objects or non-table data is highly dependent on the specific object type, your user permissions, the version of the connector, and how the report is configured.

Because this falls outside the primary scope of standard Microsoft 365 support, specialized advice from Dynamics experts is required to determine if a specific system object can be exposed for extraction.

1
Identify required objects

Make a detailed list of the specific system objects or non-table data fields you are trying to extract from Business Central.

2
Verify account permissions

Check with your system administrator to ensure your Dynamics 365 user account has the necessary read and API access permissions for those objects.

3
Visit the Dynamics community

Navigate to the official Microsoft Dynamics 365 Community forums. Search for existing topics on the specific objects you wish to extract, or post a new question including your Jet Reports version.

Consult the Microsoft Dynamics 365 Community
External Support Recommended: For definitive answers regarding specific system objects, always consult the official Jet Reports documentation or the Microsoft Dynamics 365 Community.
Free Microsoft Office alternative

Need a Reliable Alternative for Analyzing Exported Business Data?

If you are exporting data from Dynamics 365 Business Central to CSV or Excel formats for reporting, WPS Office provides a lightweight, highly compatible, and free alternative to Microsoft Excel. It handles large datasets efficiently while maintaining a familiar user interface.

  1. 1. Export your data: Use the native 'Open in Excel' or CSV export features in Dynamics 365 Business Central to save your data locally.
  2. 2. Open with WPS Spreadsheets: Launch WPS Office and open the exported .xlsx or .csv file to view your data with perfect formatting retention.
  3. 3. Analyze and format: Utilize built-in WPS features like conditional formatting, PivotTables, and advanced formulas to build your reports.
Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv files.Lightweight architecture ensures fast loading of large data exports from Business Central.Familiar spreadsheet interface makes creating PivotTables and charts effortless.Completely free to download and use, significantly reducing your software licensing costs.
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I see certain Dynamics 365 system objects in Jet Reports?

The visibility of system objects in Jet Reports depends on your Dynamics 365 permissions and whether the connector is configured to expose those specific objects via the API. You may need administrative assistance to adjust data exposure settings.

Is Jet Reports fully compatible with Business Central online?

Yes, Jet Reports is designed to integrate with Business Central online. However, it relies on exposed web services and APIs. Heavily customized extensions or hidden system tables might require specialized queries to access.

Can I export Business Central data directly to a spreadsheet without an add-in?

Yes. Microsoft Dynamics 365 Business Central includes native functionality to export lists and tables directly to spreadsheet formats. You can use the 'Open in Excel' or 'Edit in Excel' actions available on most page menus.