The Item Purchasing Report can be configured to load data based on either a Start/End Date or a Relative Date. The four fields listed below are used in combination to configure either setting.
These settings help improve performance of your Business Central system and reduce refresh times in Power BI by only loading the data you intend to analyse.
Setting Items Purchases Report Load Data Type to Relative Date will allow you to apply custom date formulas using Business Centrals date formula syntax. See this resource for me details Entering dates and times in Business Central – Business Central | Microsoft Learn.
| No. | Field Name | Description |
|---|---|---|
| 1 | Item Purchases Report Load Data Type | Defines a method to load data: – Start/End Date – Relative Date |
| 2 | Item Purchases Report Start Date | Specifies the starting date when Item Purchases Report Load Data Type is set to Start/End Date |
| 3 | Item Purchases Report End Date | Specifies the end date when Item Purchases Report Load Data Type is set to Start/End Date |
| 4 | Item Purchases Report Date Formula | Specifies the date formula when Item Purchases Report Load Data Type is set to Relative Date |
