Can Jet Reports Extract All Dynamics 365 Business Central Data?
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.

- 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.
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.
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.
Make a detailed list of the specific system objects or non-table data fields you are trying to extract from Business Central.
Check with your system administrator to ensure your Dynamics 365 user account has the necessary read and API access permissions for those objects.
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.

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. Export your data: Use the native 'Open in Excel' or CSV export features in Dynamics 365 Business Central to save your data locally.
- 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. Analyze and format: Utilize built-in WPS features like conditional formatting, PivotTables, and advanced formulas to build your reports.

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.




