BC Observatoryunofficial, made by waldo
topic hubReporting & Analyticsofficial - Microsoftreviewed - checked by Opus

Power BI apps for Business Central

Power BI apps for Business Central: how to install the connector and template apps, set up standard, fiscal, or week-based calendars, and use the semantic models and KPIs by functional area. Also covers multi-language use, back links to source documents, and FAQ topics such as licensing and refresh.

Open in Claudepower-bi-apps-for-business-central.md

Path: Analytics, business intelligence, and reporting > KPIs, dashboards, and financial reports > Power BI apps for Business Central · tier official · system reporting · narrative reviewed (checked by Opus)

Overview

Power BI apps for Business Central give you ready-made semantic models and KPIs for areas such as Finance, Sales, Purchasing, Inventory, Projects, Manufacturing, Subscription Billing, and Sustainability. There are no subtopics; all pages sit at one level.

Start with the install page. It covers the Power BI connector apps, the template apps from Marketplace, calendar and date settings, UTC offset, and semantic model management. Then pick a calendar type. The three calendar pages cover standard (Gregorian), fiscal (month-based), and week-based setups. The fiscal calendar is set up on the Power BI Reports Setup page.

After setup, the functional areas page describes what each app offers. Back links let you move from an aggregated visual to the transactional documents in Business Central. The multi-language page and the FAQ cover language testing, licensing, data refresh, dimension data, and multi-company reporting.

Key points

  • Install covers connector apps, template apps from Marketplace, calendar and date configuration, and UTC offset; it references versions 26 and 27.0.
  • Standard calendar type uses a Gregorian month structure with Calendar Year, Month, and Quarter fields and standard time intelligence measures.
  • Fiscal calendar setup is done on the Power BI Reports Setup page; it defines the fiscal year structure and first month, and enables fiscal time intelligence.
  • Week-based calendar setup defines First Day of Week, First Month of Fiscal Calendar, a Nearest or Last boundary rule, and a 445, 454, or 544 period pattern.
  • Functional area apps provide semantic models and KPIs for Finance, Sales, Purchasing, Inventory, Projects, Manufacturing, Subscription Billing, and Sustainability.
  • Back links navigate from aggregated visuals to source transactions and documents in Business Central, for validation and reconciliation.
  • Multi-language use is tested by adding a culture name parameter to the URL.
  • The FAQ covers Power BI Pro licensing, semantic model refresh, dimension data updates, job queue scheduling, and multi-company reporting; it references versions 26.2 and 27.0.

Learn pages

Videos and posts

Linked by a Haiku matcher with a grounding quote from the item’s summary (link/topics.ts); machine-generated.

Business Central pages and reports

The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.

What Learn documents here 8 Learn pages