pageReporting & Analyticsofficial - Microsoftderived - from the source, no model text

Page 36951 "PowerBI Reports Setup"

PowerBIReports · Microsoft.PowerBIReports

47controls
5actions
1procedures
14Learn pages

Open in Claude 36951.md Source on GitHub

Across versions

BC23-28not present
BC29-30present

PowerBIReports · Microsoft.PowerBIReports · captioned “Power BI Reports Setup” · BC29-30 · source at ea08af5e · 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	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	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	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	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	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	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	Specifies the starting period for the Fiscal Weekly calendar.
	FirstDayOfWeek_Weekly	First Day Of Week	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	Specifies which country to use in order to set the holidays in the calendar as non-working days
	WeeklyType	Weekly Type	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	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	Specifies the starting date reference for the Power BI Date table.
	Ending Date	Date Table Ending Date	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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”
	Power BI Account Categories	Set up your G/L account categories in the Power BI Finance reports.	Page 36961 “Account Categories”
	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.”
	ABC Analysis Setup	Set up your ABC analysis thresholds in the Power BI Inventory reports.	Page 7160 “ABC Analysis Setup”

Procedures

1 local procedures, no public ones.

Triggers

OnOpenPage, OnAfterGetCurrRecord, OnQueryClosePage

Relations

source table Table 36951 “PowerBI Reports Setup”

Extended by

Recent changes

2026-10-05 #12242 29.x: Removing the restriction of deploying Power BI reports only to evaluation companies (releases/29.x, BC29, feature)
2026-10-02 #12189 Removing the restriction of deploying Power BI reports only to evaluation companies (main, BC30, feature)
2026-08-13 #10159 Warn when missing Power BI Account Categories Mappings (main, BC30, feature)

Documented on Microsoft Learn

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.

Evidence 8 of 15 sources

Show 7 more

In the galaxy

Neighbourhood

3 links in the explorer →

Provenance

Tier: official
Review: derived
Generated: 2026-10-11
Pipeline: 0.2.0
Input: 3db8ed00d6f9
Id: object/page/36951