--- id: object/page/36951 type: object title: Page 36951 "PowerBI Reports Setup" summary: Page 36951 "PowerBI Reports Setup" in PowerBIReports (Microsoft.PowerBIReports). Introduced in BC29, still in BC30. tier: official language: en tags: - page - 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: 3db8ed00d6f9d1df1f764724f87e42040cbfa656aa1d35698315c30be512fba1 evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/PowerBIReports/app/Core/Pages/PowerBIReportsSetup.Page.al title: src/Apps/W1/PowerBIReports/app/Core/Pages/PowerBIReportsSetup.Page.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null - kind: learn url: https://learn.microsoft.com/dynamics365/business-central/across-powerbi-apps-by-functional-area title: Power BI apps/reports for functional areas date: null commit: null t: null quote: null - kind: learn url: https://learn.microsoft.com/dynamics365/business-central/across-powerbi-apps-faq title: Power BI apps FAQ date: null commit: null t: null quote: null - kind: learn url: https://learn.microsoft.com/dynamics365/business-central/across-powerbi-business-central-apps title: Use the Business Central apps in Power BI date: null commit: null t: null quote: null - kind: learn url: https://learn.microsoft.com/dynamics365/business-central/across-powerbi-configure-fiscal-calendar title: Configure a fiscal calendar for your Power BI reports date: null commit: null t: null quote: null - kind: learn url: https://learn.microsoft.com/dynamics365/business-central/across-powerbi-configure-standard-calendar title: Configure a standard calendar for your Power BI reports date: null commit: null t: null quote: null - kind: learn url: https://learn.microsoft.com/dynamics365/business-central/across-powerbi-configure-week-based-calendar title: Configure a week-based calendar date: null commit: null t: null quote: null - kind: learn url: https://learn.microsoft.com/dynamics365/business-central/across-powerbi-install-business-central-apps title: Install Power BI apps for Business Central date: null commit: null t: null quote: null - kind: learn url: https://learn.microsoft.com/dynamics365/business-central/inventory-powerbi-abc-analysis title: ABC Analysis (Power BI Report) date: null commit: null t: null quote: null - kind: learn url: https://learn.microsoft.com/dynamics365/business-central/manufacturing-powerbi-app title: Power BI Manufacturing app date: null commit: null t: null quote: null - kind: learn url: https://learn.microsoft.com/dynamics365/business-central/projects-powerbi-app title: Power BI Projects app page (Power BI report) date: null commit: null t: null quote: null - kind: learn url: https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-app title: Power BI Purchase app date: null commit: null t: null quote: null - kind: learn url: https://learn.microsoft.com/dynamics365/business-central/sales-powerbi-app title: Power BI Sales app date: null commit: null t: null quote: null - kind: learn url: https://learn.microsoft.com/dynamics365/business-central/SRB/analytics/subscription-powerbi-app title: Power BI Subscription Billing app date: null commit: null t: null quote: null - kind: learn url: https://learn.microsoft.com/dynamics365/business-central/sustainability-powerbi-app title: Sustainability Power BI app date: null commit: null 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: [] changes: - change/bcapps/12242 - change/bcapps/12189 - change/bcapps/10159 object_type: page object_id: 36951 name: PowerBI Reports Setup caption: Power BI Reports Setup 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: - docs/learn-smb-docs/business-central/across-powerbi-apps-by-functional-area.md - docs/learn-smb-docs/business-central/across-powerbi-apps-faq.md - docs/learn-smb-docs/business-central/across-powerbi-business-central-apps.md - docs/learn-smb-docs/business-central/across-powerbi-configure-fiscal-calendar.md - docs/learn-smb-docs/business-central/across-powerbi-configure-standard-calendar.md - docs/learn-smb-docs/business-central/across-powerbi-configure-week-based-calendar.md - docs/learn-smb-docs/business-central/across-powerbi-install-business-central-apps.md - docs/learn-smb-docs/business-central/inventory-powerbi-abc-analysis.md - docs/learn-smb-docs/business-central/manufacturing-powerbi-app.md - docs/learn-smb-docs/business-central/projects-powerbi-app.md - docs/learn-smb-docs/business-central/purchases-powerbi-app.md - docs/learn-smb-docs/business-central/sales-powerbi-app.md - docs/learn-smb-docs/business-central/SRB/analytics/subscription-powerbi-app.md - docs/learn-smb-docs/business-central/sustainability-powerbi-app.md counts: fields: 0 procedures: 1 events: 0 subscribers: 0 controls: 47 actions: 5 relations: out: 1 referenced_by: 0 pages: 0 extended_by: 2 event_subscribers: 0 calls: 0 called_by: 0 implements: 0 --- # Page 36951 "PowerBI Reports Setup" > Page 36951 "PowerBI Reports Setup" in PowerBIReports (Microsoft.PowerBIReports). Introduced in BC29, still in BC30. PowerBIReports · Microsoft.PowerBIReports · captioned "Power BI Reports Setup" · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/PowerBIReports/app/Core/Pages/PowerBIReportsSetup.Page.al) · facts from BC29 ## Properties | Property | Value | |---|---| | Caption | Power BI Reports Setup | | SourceTable | PowerBI Reports Setup | | UsageCategory | Administration | | ApplicationArea | All | ## Fields on this page Layout controls in source order, grouped by the container they sit in. Shows: the table field a control is bound to (or its expression as written); ToolTip: the control's own, else the bound field's (marked). | Group | Control | Shows | ToolTip | |---|---|---|---| | EnvironmentDetails | Environment name | `Text.UpperCase(EnvironmentInformation.GetEnvironmentName())` | Specifies the name for the environment used to connect Business Central to a Power BI semantic model. | | | Company Name | `CompanyName` | Specifies the name of the company used to connect Business Central to a Power BI semantic model. Note: this parameter is case sensitive. ) | | | Power BI Workspace | `PowerBIWorkspaceName` | Specifies the Power BI workspace that Power BI reports are deployed to. The workspace is configured on the Company Information page. | | Connection Details | ViewDeveloperDoc | `ViewDeveloperDocLbl` | Click here to view the developer documentation. | | CalendarDetails | Calendar Type | [Calendar Range](../table/36951.md#fields) | 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. | | Standard Calendar Configuration | FirstDayOfWeek | [First Day Of Week](../table/36951.md#fields) | 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). | | | IsoCountryHolidays | [ISO Country Holidays](../table/36951.md#fields) | 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 | | Fiscal Monthly Calendar Configuration | FCalendarFirstMonth | [First Month of Fiscal Calendar](../table/36951.md#fields) | Specifies the first month of the Fiscal calendar. If set to 1, the fiscal monthly calendar is identical to the standard calendar. | | | FirstDayOfWeek_Fiscal | [First Day Of Week](../table/36951.md#fields) | Specifies the first day of a week. US calendars typically use start on Sunday, whereas European calendars start on Monday. | | | IsoCountryHolidays_Fiscal | [ISO Country Holidays](../table/36951.md#fields) | Specifies which country to use in order to set the holidays in the calendar as non-working days. A fiscal monthly calendar where the year starts on the first day of a month that is not January. | | Fiscal Weekly Calendar Configuration | First Month of Fiscal Weekly Calendar | [First Month of Fiscal Calendar](../table/36951.md#fields) | Specifies the starting period for the Fiscal Weekly calendar. | | | FirstDayOfWeek_Weekly | [First Day Of Week](../table/36951.md#fields) | Specifies the first day of a week and defines when a week starts in the Fiscal Weekly calendar. US calendars typically start on Sunday, whereas European calendars start on Monday. | | | IsoCountryHolidays_Weekly | [ISO Country Holidays](../table/36951.md#fields) | Specifies which country to use in order to set the holidays in the calendar as non-working days | | | WeeklyType | [Weekly Type](../table/36951.md#fields) | 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. | | | QuarterWeekType | [Quarter Week Type](../table/36951.md#fields) | 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. | | UTC Offset | Time Zone | `Rec.GetTimeZoneDisplayName()` | Specifies the time zone for Power BI related dates. | | Date Table Range | Starting Date | [Date Table Starting Date](../table/36951.md#fields) | Specifies the starting date reference for the Power BI Date table. | | | Ending Date | [Date Table Ending Date](../table/36951.md#fields) | Specifies the ending date reference for the Power BI Date table. | | FinanceGeneral | Power BI Finance App | `Format(Rec."Finance Report Name")` | Specifies where you have installed the Power BI Finance App. | | Income Statement G/L Account Filters | Start Date | [Finance Start Date](../tableextension/36953.md#fields) | Specifies the start date for the Income Statement and G/L Accounts filter (if you want to restrict the amount of data that is loaded to the semantic model in Power BI). | | | End Date | [Finance End Date](../tableextension/36953.md#fields) | Specifies the end date for the Income Statement and G/L Accounts filter (if you want to restrict the amount of data that is loaded to the semantic model in Power BI). | | Customer Ledger Entry Filters | Start Date | [Cust. Ledger Entry Start Date](../tableextension/36953.md#fields) | Specifies the start date for the Customer Ledger Entries filter (if you want to restrict the amount of data that is loaded to the semantic model in Power BI). | | | End Date | [Cust. Ledger Entry End Date](../tableextension/36953.md#fields) | Specifies the end date for the Customer Ledger Entries filter (if you want to restrict the amount of data that is loaded to the semantic model in Power BI). | | Vendor Ledger Entry Filters | Start Date | [Vend. Ledger Entry Start Date](../tableextension/36953.md#fields) | Specifies the start date for the Vendor Ledger Entries filter (if you want to restrict the amount of data that is loaded to the semantic model in Power BI). | | | End Date | [Vend. Ledger Entry End Date](../tableextension/36953.md#fields) | Specifies the end date for the Vendor Ledger Entries filter (if you want to restrict the amount of data that is loaded to the semantic model in Power BI). | | SalesGeneral | Power BI Sales App | `Format(Rec."Sales Report Name")` | Specifies where you have installed the Power BI Sales App. | | Sales Report | Item Sales Load Date Type | [Item Sales Load Date Type](../tableextension/36958.md#fields) | Specifies the date filtering type for Item Sales 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 mont... | | Item Sales Start End Date Filters | Item Sales Start Date | [Item Sales Start Date](../tableextension/36958.md#fields) | Specifies the start date for Item Sales report filter. Set this if you have specified Start/End Date as the Load Date Type. | | | Item Sales End Date | [Item Sales End Date](../tableextension/36958.md#fields) | Specifies the end date for Item Sales report filter. Set this if you have specified Start/End Date as the Load Date Type. | | Item Sales Relative Date Filter | Item Sales Date Formula | [Item Sales Date Formula](../tableextension/36958.md#fields) | Specifies the date formula for Item Sales report filter. Set this if you have specified Relative Date as the Load Date Type. | | PurchasesGeneral | Power BI Purchases App | `Format(Rec."Purchases Report Name")` | Specifies where you have installed the Power BI Purchases App. | | Purchases Report | Item Purch. Load Date Type | [Item Purch. Load Date Type](../tableextension/36956.md#fields) | 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. | | Item Purch. Start End Date Filters | Item Purch. Start Date | [Item Purch. Start Date](../tableextension/36956.md#fields) | Specifies the start date for Item Purchases report filter. Set this if you have specified Start/End Date as the Load Date Type. | | | Item Purch. End Date | [Item Purch. End Date](../tableextension/36956.md#fields) | Specifies the end date for Item Purchases report filter. Set this if you have specified Start/End Date as the Load Date Type. | | Item Purch. Relative Date Filter | Item Purch. Date Formula | [Item Purch. Date Formula](../tableextension/36956.md#fields) | Specifies the date formula for Item Purchases report filter. Set this if you have specified Relative Date as the Load Date Type. | | InventoryGeneral | Power BI Inventory App | `Format(Rec."Inventory Report Name")` | Specifies where you have installed the Power BI Inventory App. | | | Power BI Inventory Valuation App | `Format(Rec."Inventory Val. Report Name")` | Specifies where you have installed the Power BI Inventory Valuation App. | | ProjectsGeneral | Power BI Projects App | `Format(Rec."Projects Report Name")` | Specifies where you have installed the Power BI Projects App. | | Projects Ledger Entry Filters | Start Date | [Job Ledger Entry Start Date](../tableextension/36955.md#fields) | Specifies the start date for Projects Ledger Entries filter (if you want to restrict the amount of data that is loaded to the semantic model in Power BI). | | | End Date | [Job Ledger Entry End Date](../tableextension/36955.md#fields) | Specifies the end date for Projects Ledger Entries filter (if you want to restrict the amount of data that is loaded to the semantic model in Power BI). | | ManufacturingGeneral | Power BI Manufacturing App | `Format(Rec."Manufacturing Report Name")` | Specifies where you have installed the Power BI Manufacturing App. | | Manufacturing Report | Manufacturing Load Date Type | [Manufacturing Load Date Type](../tableextension/36954.md#fields) | Specifies the date type for Manufacturing 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. | | Manufacturing Start End Date Filters | Manufacturing Start Date | [Manufacturing Start Date](../tableextension/36954.md#fields) | Specifies the start date for Manufacturing report filter. Set this if you have specified Start/End Date as the Load Date Type. | | | Manufacturing End Date | [Manufacturing End Date](../tableextension/36954.md#fields) | Specifies the end date for Manufacturing report filter. Set this if you have specified Start/End Date as the Load Date Type. | | Manufacturing Relative Date Filter | Manufacturing Date Formula | [Manufacturing Date Formula](../tableextension/36954.md#fields) | Specifies the date formula for Manufacturing report filter. Set this if you have specified Relative Date as the Load Date Type. | | SubscriptionBillingGeneral | Power BI Subscription Billing App obsolete Pending 28.0; #if not CLEAN28 | `Format(Rec."Subs. Billing Report Name")` | Specifies where you have installed the Power BI Subscription Billing App. | | Dimensions | LastDimensionSetEntryDateTime | [Last Dim. Set Entry Date-Time](../table/36951.md#fields) | 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. | ## Actions | Group | Action | ToolTip | Runs | |---|---|---|---| | Processing | Schedule Power BI Dimension Refresh | Create a job queue entry that will refresh Power BI Dimension Set Entries in the background. This is required for dimensions to be displayed in Power BI Reports. | | | | Working Days | Specifies the working days of the week. | [Page 36952 "Working Days Setup"](../page/36952.md) | | | Power BI Account Categories | Set up your G/L account categories in the Power BI Finance reports. | [Page 36961 "Account Categories"](../page/36961.md) | | | Close Income Statement Source Codes | Setup your close income statement source codes in the Power BI Finance reports. | [Page 36964 "PBI Close Income Stmt. SC."](../page/36964.md) | | | ABC Analysis Setup | Set up your ABC analysis thresholds in the Power BI Inventory reports. | [Page 7160 "ABC Analysis Setup"](../page/7160.md) | ## Procedures 1 local procedures, no public ones. ## Triggers OnOpenPage, OnAfterGetCurrRecord, OnQueryClosePage ## Relations - source table [Table 36951 "PowerBI Reports Setup"](../table/36951.md) ## Extended by - [Page extension 6261 "Sust. PBI Reports Setup"](../pageextension/6261.md) - [Page extension 8011 "SubBill PBI Reports Setup"](../pageextension/8011.md) ## Recent changes - 2026-10-05 [#12242 29.x: Removing the restriction of deploying Power BI reports only to evaluation companies](../../changes/bcapps/12242.md) (releases/29.x, BC29, feature) - 2026-10-02 [#12189 Removing the restriction of deploying Power BI reports only to evaluation companies](../../changes/bcapps/12189.md) (main, BC30, feature) - 2026-08-13 [#10159 Warn when missing Power BI Account Categories Mappings](../../changes/bcapps/10159.md) (main, BC30, feature) ## Across versions - Present in: BC29-30 - Changed (declaration) in: none ## Documented on Microsoft Learn - [Power BI apps/reports for functional areas](https://learn.microsoft.com/dynamics365/business-central/across-powerbi-apps-by-functional-area) - [Power BI apps FAQ](https://learn.microsoft.com/dynamics365/business-central/across-powerbi-apps-faq) - [Use the Business Central apps in Power BI](https://learn.microsoft.com/dynamics365/business-central/across-powerbi-business-central-apps) - [Configure a fiscal calendar for your Power BI reports](https://learn.microsoft.com/dynamics365/business-central/across-powerbi-configure-fiscal-calendar) - [Configure a standard calendar for your Power BI reports](https://learn.microsoft.com/dynamics365/business-central/across-powerbi-configure-standard-calendar) - [Configure a week-based calendar](https://learn.microsoft.com/dynamics365/business-central/across-powerbi-configure-week-based-calendar) - [Install Power BI apps for Business Central](https://learn.microsoft.com/dynamics365/business-central/across-powerbi-install-business-central-apps) - [ABC Analysis (Power BI Report)](https://learn.microsoft.com/dynamics365/business-central/inventory-powerbi-abc-analysis) - [Power BI Manufacturing app](https://learn.microsoft.com/dynamics365/business-central/manufacturing-powerbi-app) - [Power BI Projects app page (Power BI report)](https://learn.microsoft.com/dynamics365/business-central/projects-powerbi-app) - [Power BI Purchase app](https://learn.microsoft.com/dynamics365/business-central/purchases-powerbi-app) - [Power BI Sales app](https://learn.microsoft.com/dynamics365/business-central/sales-powerbi-app) - [Power BI Subscription Billing app](https://learn.microsoft.com/dynamics365/business-central/SRB/analytics/subscription-powerbi-app) - [Sustainability Power BI app](https://learn.microsoft.com/dynamics365/business-central/sustainability-powerbi-app) 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: "page", object_name: "PowerBI Reports Setup")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.