Table 36951 "PowerBI Reports Setup"
PowerBIReports · Microsoft.PowerBIReports
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 25 connected objects and pages
PowerBIReports · Microsoft.PowerBIReports · captioned “Setup for Power BI Connector” · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 36951 “PowerBI Reports Setup” (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” | 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” | 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” | 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” | 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” | 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” | 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” | 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” | 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” | 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” (source table)
- Page 36951 “PowerBI Reports Setup” (source table)
- Page 36955 “Date Setup” (source table)
Extended by
- Table extension 36953 “Setup - Finance”
- Table extension 36954 “Setup - Manufacturing”
- Table extension 36955 “Setup - Projects”
- Table extension 36956 “Setup - Purchases”
- Table extension 36957 “Setup - Sustainability”
- Table extension 36958 “Setup - Sales”
- Table extension 36960 “Setup - Inventory”
- Table extension 36961 “Setup - Subscription Billing”
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.