Electronic reporting – query reuse for performance improvements

  • Article

Important

This content is archived and is not being updated. For the latest documentation, go to What's new or changed in Dynamics 365 Finance. 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 Aug 1, 2021 Oct 1, 2021

Business value

This feature improves the performance of electronic reporting formats that have multiple queries.

Feature details

If there are similar queries and the only difference between them is in the applied ranges, this feature reuses an existing query instead of creating a new one. This improvement applies to:

  • The FILTER expression.
  • A JOIN constructed from FILTER expressions.