--- id: object/table/36951 type: object title: Table 36951 "PowerBI Reports Setup" summary: Table 36951 "PowerBI Reports Setup" in PowerBIReports (Microsoft.PowerBIReports). 16 fields, 2 public procedures. Introduced in BC29, still in BC30. tier: official language: en tags: - table - 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: d62bcc3f90d9c8b9d002ff9bd520c8e6b306f085fcf2dcc3bef7587219d92a64 evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/PowerBIReports/app/Core/Tables/PowerBIReportsSetup.Table.al title: src/Apps/W1/PowerBIReports/app/Core/Tables/PowerBIReportsSetup.Table.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null links: learn: - https://learn.microsoft.com/dynamics365/business-central/across-powerbi-apps-by-functional-area - https://learn.microsoft.com/dynamics365/business-central/across-powerbi-apps-faq - https://learn.microsoft.com/dynamics365/business-central/across-powerbi-business-central-apps - https://learn.microsoft.com/dynamics365/business-central/across-powerbi-configure-fiscal-calendar - https://learn.microsoft.com/dynamics365/business-central/across-powerbi-configure-standard-calendar - https://learn.microsoft.com/dynamics365/business-central/across-powerbi-configure-week-based-calendar - https://learn.microsoft.com/dynamics365/business-central/across-powerbi-install-business-central-apps - https://learn.microsoft.com/dynamics365/business-central/inventory-powerbi-abc-analysis - https://learn.microsoft.com/dynamics365/business-central/manufacturing-powerbi-app - https://learn.microsoft.com/dynamics365/business-central/projects-powerbi-app - https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-app - https://learn.microsoft.com/dynamics365/business-central/sales-powerbi-app - https://learn.microsoft.com/dynamics365/business-central/SRB/analytics/subscription-powerbi-app - https://learn.microsoft.com/dynamics365/business-central/sustainability-powerbi-app objects: [] features: [] topics: - topic/business-central/analytics-business-intelligence-and-repo/kpis-dashboards-and-financial-reports/power-bi-apps-for-business-central - topic/business-central/business-functionality/inventory/inventory-analytics/power-bi-inventory-app - topic/business-central/business-functionality/manufacturing/manufacturing-analytics/power-bi-manufacturing-app - topic/business-central/business-functionality/project-management/project-management-analytics/power-bi-projects-app - topic/business-central/business-functionality/purchasing/purchasing-analytics/power-bi-purchasing-app - topic/business-central/business-functionality/sales/sales-analytics/power-bi-sales-app - topic/business-central/business-functionality/sales/subscription-billing/subscription-billing-analytics - topic/business-central/business-functionality/sustainability-management/sustainability-analytics/power-bi-sustainability-app - topic/business-central/integrate-with-other-applications/microsoft-power-platform/microsoft-power-bi localizations: [] videos: [] posts: [] guidelines: [] object_type: table object_id: 36951 name: PowerBI Reports Setup caption: Setup for Power BI Connector namespace: Microsoft.PowerBIReports app: PowerBIReports extends: null first_version: "29" last_version: "30" present_in: - "29" - "30" changed_in: [] source_major: "29" obsolete: null countries: [] ms_search_form_ids: [] counts: fields: 16 procedures: 2 events: 0 subscribers: 0 relations: out: 0 referenced_by: 0 pages: 3 extended_by: 8 event_subscribers: 0 calls: 0 called_by: 0 implements: 0 --- # Table 36951 "PowerBI Reports Setup" > Table 36951 "PowerBI Reports Setup" in PowerBIReports (Microsoft.PowerBIReports). 16 fields, 2 public procedures. Introduced in BC29, still in BC30. PowerBIReports · Microsoft.PowerBIReports · captioned "Setup for Power BI Connector" · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/PowerBIReports/app/Core/Tables/PowerBIReportsSetup.Table.al) · facts from BC29 Learn documents this table through its pages: [Page 36951 "PowerBI Reports Setup"](../page/36951.md) (14 Learn pages). ## Properties | Property | Value | |---|---| | Caption | Setup for Power BI Connector | ## 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 | |---|---|---|---|---| | 1 | Entry No. | Code[10] | — | DataClassification CustomerContent | | 2 | First Month of Fiscal Calendar | Integer | Specifies the first month of the Fiscal calendar. If set to 1, the fiscal monthly calendar is identical to the standard calendar. via [Page 36951 "PowerBI Reports Setup"](../page/36951.md) | DataClassification CustomerContent | | 3 | First Day Of Week | Option | Specifies the first day of a week and defines when a week starts in a weekly calendar. US calendars typically use 0 (Sunday), whereas European calendars use 1 (Monday). via [Page 36951 "PowerBI Reports Setup"](../page/36951.md) | OptionCaption: Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday; DataClassification CustomerContent | | 4 | ISO Country Holidays | Option | Specifies which country to use in order to set the holidays in the calendar as non-working days. A standard monthly calendar that begins on January 1 and ends on December 31 via [Page 36951 "PowerBI Reports Setup"](../page/36951.md) | OptionCaption: AT,AU,BE,CA,DE,ES,FR,GB,IT,NL,NO,PT,SE,US; DataClassification CustomerContent | | 5 | Weekly Type | Option | Specifies the end of the year definition for the Fiscal Weekly calendar. Last: Last weekday of the month at Fiscal year end. Nearest: Last weekday nearest the end of month. via [Page 36951 "PowerBI Reports Setup"](../page/36951.md) | OptionCaption: Last,Nearest; DataClassification CustomerContent | | 6 | Quarter Week Type | Option | Specifies the number of weeks per period in each quarter. Quarters which always count 13 weeks in the Fiscal Weekly calendar. A fiscal weekly calendar that supports: 4-4-5, 4-5-4, or 5-4-4. via [Page 36951 "PowerBI Reports Setup"](../page/36951.md) | OptionCaption: 445,454,544; DataClassification CustomerContent | | 7 | Calendar Range | Option | Specifies which type of calendar the year boundaries are applied to during Date table generation in Power BI. Using Weekly, the first and last day of the year might not correspond to a first and last day of a month, respectively. via [Page 36951 "PowerBI Reports Setup"](../page/36951.md) | OptionCaption: Standard,Fiscal Calendar,Weekly; DataClassification CustomerContent | | 8 | Calendar Gregorian Prefix | Text[10] | — | DataClassification CustomerContent | | 9 | Fiscal Gregorian Prefix | Text[10] | — | DataClassification CustomerContent | | 10 | Fiscal Weekly Prefix | Text[10] | — | DataClassification CustomerContent | | 12 | Use Custom Fiscal Periods | Boolean | — | DataClassification CustomerContent | | 13 | Ignore Weekly Fiscal Periods | Boolean | — | DataClassification CustomerContent | | 15 | Date Table Starting Date | Date | Specifies the starting date reference for the Power BI Date table. via [Page 36951 "PowerBI Reports Setup"](../page/36951.md) | DataClassification CustomerContent | | 16 | Date Table Ending Date | Date | Specifies the ending date reference for the Power BI Date table. via [Page 36951 "PowerBI Reports Setup"](../page/36951.md) | DataClassification CustomerContent | | 17 | Last Dim. Set Entry Date-Time | DateTime | Specifies when the last Dimension Set Entry was inserted or modified in the database. To improve performance, the "Update Power BI Dimension Set Entries" job queue entry will retrieve and insert Dimension Set Entry records from this point onwards. via [Page 36951 "PowerBI Reports Setup"](../page/36951.md) | DataClassification CustomerContent | | 18 | Time Zone | Text[180] | — | DataClassification SystemMetadata | ## Keys - PK: Entry No. ## Procedures - `GetOrCreate()` - `GetTimeZoneDisplayName(): Text[250]` ## Pages and codeunits on this table - [Page 36950 "PowerBI Assisted Setup"](../page/36950.md) (source table) - [Page 36951 "PowerBI Reports Setup"](../page/36951.md) (source table) - [Page 36955 "Date Setup"](../page/36955.md) (source table) ## Extended by - [Table extension 36953 "Setup - Finance"](../tableextension/36953.md) - [Table extension 36954 "Setup - Manufacturing"](../tableextension/36954.md) - [Table extension 36955 "Setup - Projects"](../tableextension/36955.md) - [Table extension 36956 "Setup - Purchases"](../tableextension/36956.md) - [Table extension 36957 "Setup - Sustainability"](../tableextension/36957.md) - [Table extension 36958 "Setup - Sales"](../tableextension/36958.md) - [Table extension 36960 "Setup - Inventory"](../tableextension/36960.md) - [Table extension 36961 "Setup - Subscription Billing"](../tableextension/36961.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: "table", object_name: "PowerBI Reports Setup")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.