New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Delete Data from Uninstalled Extensions as an Admin

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2.

The sixth of the new functionality in the Governance and Administration section is Delete data from uninstalled extensions as an admin.

Before this change, when administrators uninstalled an extension but didn’t delete its data, they had to raise a support case or reinstall the extension to do so. Administrators can now easily delete data for an extension after they uninstall it, which saves time and effort.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: Sep 2023
General Availability: Oct 2023

Feature Details

The Extension Management page gives administrators access to the extensions that are installed on their tenant. However, the page doesn’t list extensions that were uninstalled before their data was deleted. This situation might mean that the tenant is storing unneeded data from old extensions. It can also result in reduced performance because the data model for table extensions loads data from uninstalled extensions. Administrators can quickly delete old data to avoid these potential problems.

To address these issues, Microsoft have introduced the Delete Orphaned Extension Data page. To delete data, on the Delete Orphaned Extension Data page, select the extensions, and then choose Delete Data.

My Opinion

This is a nice addition to housekeeping on the database. There may be times when you want to remove an extension but retain the data for a while. This enhancement means you can do this and then remove the data when it is no longer required, without needing to reinstall the extension to do so.

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Include or Exclude Tables From Cloud Migration

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2.

The fourth of the new functionality in the Governance and Administration section is Include or exclude tables from cloud migration.

Explicitly including or excluding certain tables from cloud migration runs will make it easier to specify what data you want to migrate to the cloud.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: –
General Availability: Nov 2023

Feature Details

Some customers need the flexibility to migrate only specific data to the cloud, based on their unique requirements. Microsoft now make it possible to specify whether any table is included or excluded as part of the cloud migration—as long as the table is accessible by AL code and not marked as internal or on-premises only.

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2

New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Define multi-worksheet datasets for Excel reports

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2.

The twenty-eighth of the new functionality in the Development section is Define multi-worksheet datasets for Excel reports.

AL developers can now define AL report datasets so that when running with Excel layouts, multiple top-level data items are stored in their own worksheets in Excel. This makes data models such as parent-child easier to model in Excel, and enables them to use powerful modeling tools such as PowerPivot in Excel.

Enabled for: Users by admins, makers, or analysts
Public Preview: Oct 2023
General Availability: Dec 2023

Feature Details

Prior to this release, developers who wanted to create an Excel report on a data model with multiple top-level data items, such as a parent-child relationship, had to do a lot of extra modeling in Excel to separate the two before they could use that data in the Excel layout.

With this release, the developer can set a new ExcelLayoutMultipleDataSheets property to True. The AL runtime will generate an Excel worksheet for each data item and place its data there.

Multiple sheets will be named #DataItemName, where DataItemName is the dataitem name in the report design. Adding new empty Excel layouts to the report uses the property value to determine the sheet structure.

Example of how to model data with PowerPivot in the Excel layout

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Define multi-worksheet datasets for Excel reports”