Day: September 24, 2024

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Use Advanced Settings In The Power Bi Connector

Ian Grieve4 minute read0 comment

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

The 3rd of the new functionality in the Reporting and data analysis section is use advanced settings in the Power BI connector.

Advanced users of Power Query can now fine-tune the use of the Power BI connector for Business Central in their semantic models. The introduction of new parameters to the Power BI connector for Business Central enhances the flexibility, performance, and user experience of data integration and analysis, while still ensuring the default values are optimal in the majority of cases. These parameters empower users with more control over their data interactions, leading to more efficient data processing, better performance, and an improved user experience.

Enabled for: Users by admins, makers, or analysts
Public Preview: –
General Availability: Oct 2024

Feature Details

Starting in this release, the Power BI connector for Business Central now supports several advanced properties that you can set in your Power Query queries:

  • AcceptLanguage: This parameter allows you to specify preferred languages for responses, ensuring users receive messages and translatable strings in their desired language. This improves user satisfaction and makes the data more accessible and relevant.
  • ODataMaxPageSize: By limiting the number of entities per results page, this parameter allows for more flexibility when connecting to large datasets or using complex queries. It ensures efficient and responsive data retrieval, leading to faster insights and decision-making. You can’t exceed the maximum page size defined on the service.
  • Timeout: This parameter defines the maximum duration for a request before cancellation. It helps manage system resources effectively and prevents long-running queries from impacting overall system performance. Users experience minimal delays and interruptions, ensuring a smoother workflow. You can’t exceed the timeout defined on the service.
  • UseReadOnlyReplica: This parameter determines whether requests target the primary database or a read-only replica. Offloading read operations from the primary database can significantly boost performance. This leads to faster data retrieval and improved system stability, especially during peak usage times.

Click to show/hide the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2 Series Index

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Do Ad Hoc Analysis On Fixed Assets, Projects, And Services

Ian Grieve3 minute read0 comment

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

The 2nd of the new functionality in the Reporting and data analysis section is do ad hoc analysis on fixed assets, projects, and services.

Do reporting and ad hoc data analysis on transactions from fixed assets, projects, and service management: group, summarize, and pivot data to give you the insights you need without the need to run a report.

Enabled for: Users, automatically
Public Preview: –
General Availability: Oct 2024

Feature Details

In 2023 release wave 2, we introduced the ability to do data analysis on an AL query. Now, 2024 release wave 2 has out-of-the-box queries designed to make ad hoc analysis easier for fixed assets, projects, and services.

Many of the first examples are ledger entry tables (such as fixed assets ledger entries or project ledger entries) joined to relevant tables (typically the tables where a code field on the ledger can be joined) where additional fields can enrich the analysis scenarios that people typically do on ledger entry list pages.
Example: fixed assets ad hoc analysis

The fixed assets ad hoc analysis query joins data from fixed asset ledger entries to master data tables, such as the Fixed Asset, Fixed Asset Class, Fixed Asset Subclass, Fixed Asset Location, and Depreciation Book tables.

When you open the query in the Business Central client, you can slice and dice data about fixed assets any way you like. The following image shows the options that are available.

Screenshot showing analysis on fixed assets

Click to show/hide the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2 Series Index

In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the “Delete Record V3” Action

Ian Grieve2 minute read0 comment

Microsoft Dynamics 365 Business CentralThis article is part of the In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… series, a sub-series of the In Microsoft Dynamics 365 Business Central (Power Automate), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

There are a number of actions available in Power Automate for Business Central which allow specific actions against the data of Business Central to be performed from within Power Automate.

The 7th action which is available is the Delete record (V3) one which will delete records in Business Central.

Within a flow, click the add action button; search for Business Central and select the Business Central icon (make sure you select the SaaS one, which is a dark colour instead of the on-premises one which is mainly white):

Choose an action dialog with Business Central in the search results

Continue reading “In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the “Delete Record V3” Action”