---
id: object/tableextension/36956
type: object
title: Table extension 36956 "Setup - Purchases"
summary: Table extension 36956 "Setup - Purchases" in PowerBIReports (Microsoft.Purchases.PowerBIReports), extends "PowerBI Reports Setup". 6 fields. Introduced in BC29, still in BC30.
tier: official
language: en
tags:
  - tableextension
  - powerbireports
versions:
  introduced: "29"
  last_changed: null
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: ab0e9cee8a02144c4b687603e407f5145925da4e6e0eaaa224e9fe41e673934f
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/PowerBIReports/app/Purchasing/SetupPurchases.TableExt.al
    title: src/Apps/W1/PowerBIReports/app/Purchasing/SetupPurchases.TableExt.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects:
    - object/table/36951
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: tableextension
object_id: 36956
name: Setup - Purchases
namespace: Microsoft.Purchases.PowerBIReports
app: PowerBIReports
extends: PowerBI Reports Setup
first_version: "29"
last_version: "30"
present_in:
  - "29"
  - "30"
changed_in: []
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 6
  procedures: 0
  events: 0
  subscribers: 0
relations:
  out: 1
  referenced_by: 0
  pages: 0
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table extension 36956 "Setup - Purchases"

> Table extension 36956 "Setup - Purchases" in PowerBIReports (Microsoft.Purchases.PowerBIReports), extends "PowerBI Reports Setup". 6 fields. Introduced in BC29, still in BC30.

PowerBIReports · Microsoft.Purchases.PowerBIReports · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/PowerBIReports/app/Purchasing/SetupPurchases.TableExt.al) · facts from BC29

Extends [PowerBI Reports Setup](../table/36951.md).

## Fields

Explanation: the field's ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 36964 | Item Purch. Load Date Type | Option | Specifies the date type for Item Purchases report filter (if you want to restrict the amount of data that is loaded to the semantic model in Power BI). Choose Start/End Date to define an interval for which to load data. Chose Relative Date to load data based on a date formula, e.g. last 6 months. <small>via [Page 36951 "PowerBI Reports Setup"](../page/36951.md)</small> | OptionCaption: ,Start/End Date,Relative Date; DataClassification CustomerContent |
| 36965 | Item Purch. Start Date | Date | Specifies the start date for Item Purchases report filter. Set this if you have specified Start/End Date as the Load Date Type. <small>via [Page 36951 "PowerBI Reports Setup"](../page/36951.md)</small> | DataClassification CustomerContent |
| 36966 | Item Purch. End Date | Date | Specifies the end date for Item Purchases report filter. Set this if you have specified Start/End Date as the Load Date Type. <small>via [Page 36951 "PowerBI Reports Setup"](../page/36951.md)</small> | DataClassification CustomerContent |
| 36967 | Item Purch. Date Formula | DateFormula | Specifies the date formula for Item Purchases report filter. Set this if you have specified Relative Date as the Load Date Type. <small>via [Page 36951 "PowerBI Reports Setup"](../page/36951.md)</small> | DataClassification CustomerContent |
| 36974 | Purchases Report Id | Guid | Purchases Report ID <small>caption</small> | DataClassification CustomerContent |
| 36975 | Purchases Report Name | Text[200] | Specifies the Power BI Purchases Report. <small>via [Page 36950 "PowerBI Assisted Setup"](../page/36950.md)</small> | DataClassification CustomerContent |

## Relations

- extends [Table 36951 "PowerBI Reports Setup"](../table/36951.md)

## Across versions

- Present in: BC29-30
- Changed (declaration) in: none

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "tableextension", object_name: "Setup - Purchases")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.