Power BI inventory app

Path: Business functionality > Inventory > Inventory analytics > Power BI inventory app · tier official · system inventory · narrative reviewed (checked by Opus)

Overview

The Power BI inventory app gives leadership, managers, and warehouse staff data-driven views of inventory levels, stock movement, bin contents, and demand fulfillment. The app page lists the included reports, and each report has its own page describing its purpose, audience, and KPIs.

The reports fall into a few groups. Overview and location views: Inventory Overview, Inventory by Item, Inventory by Location, and Purchase and Sales Quantity. Supply and demand views: Item Availability, Gross Requirement, and Scheduled Receipt. Warehouse and tracking views: Bin Contents, Bin Contents by Item Tracking, Inventory by Lot No., and Inventory by Serial No. Analytical views: ABC Analysis and Inventory Forecasting.

Start with the app page to see the full set of reports, then the Inventory Overview report. Use the KPIs and measures page for formulas and data sources, and the semantic model page to understand the star schema behind the data.

Key points

• The app page covers inventory overview, inventory by location, bin contents, gross requirement, scheduled receipt, and ABC analysis.
• Inventory Overview and Item Availability report KPIs such as Inventory (Quantity), Scheduled Receipt, Planned Order Receipt, Gross Requirement, and Projected Available Balance.
• Item Availability helps find items where demand exceeds supply, to avoid delayed orders.
• Gross Requirement analyzes outbound demand from sales, production components, service, and assembly components. Scheduled Receipt covers inbound from purchase, production, assembly, and transfers.
• Bin Contents shows stock per bin, including available, pick, put-away, and adjustment quantities. The item tracking version adds lot and serial information in a matrix.
• Inventory by Lot No. includes an Expired Inventory KPI. Inventory by Serial No. tracks serial-tracked items and slow-moving stock.
• ABC Analysis ranks items into categories A, B, and C by sales amount, with an ABC Analysis Setup page.
• Inventory Forecasting predicts the next three months from historical data, with seasonality, location-based forecasts, and customizable parameters.

Learn pages

• ABC Analysis (Power BI Report): Rank items into A, B, and C categories based on their sales amounts to identify high-value items and inform purchasing and replenishment decisions.
• Bin Contents (Power BI report): The Bin Contents report shows bin contents per location.
• Bin Contents by Item Tracking (Power BI report): The Bin Contents by Item Tracking report shows bin contents and the lot and serial numbers in the bins.
• Gross Requirement (Power BI report): The Gross Requirement report looks at all outbound transactions within the system to identify the quantity required per item.
• Inventory by Item (Power BI report): The Inventory by Item report shows inventory levels per item or item category.
• Inventory by Location (Power BI report): The Inventory by Location outlines inventory levels across locations.
• Inventory by Lot No. (Power BI report): The Inventory by Lot No. report shows total inventory broken down per lot.
• Inventory by Serial No (Power BI report): The Inventory by Serial No. report shows your total inventory broken down per serial number.
• Inventory Forecasting (Power BI report): The Inventory Forecasting report provides insights into your organization’s inventory trends and future stock requirements.
• Inventory KPIs and measures (Power BI): The Inventory App KPIs provides a page to clearly identify all KPIs and Measures used in the Inventory Report.
• Inventory Overview (Power BI report): The Inventory Overview report provides a high-level summary of your organizations inventory.
• Inventory Power BI App Page (Power BI report): The Inventory Power BI contains different reports for an organizations inventory reporting needs
• Item Availability (Power BI report): The Item Availability report gives an overview of the availability of each item.
• Power BI Inventory app semantic model: Learn how the Power BI Inventory app semantic model organizes inventory, supply, demand, warehouse, and item dimension data from Business Central.
• Purchase and Sales Quantity (Power BI report): The Purchase and Sales Quantity report shows purchase and sales quantities for an organization.
• Scheduled Receipt (Power BI report): The Scheduled Receipt report lets you view inbound inventory per document type.

Videos and posts

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

• What’s New: Power BI for Projects and Inventory (2025 release wave 2) (video): “Inventory Forecasting Report; Seasonality Control in Forecasting”
• What’s New: Power BI Reporting for Business Central - New Apps (2024 release wave 2) (video): “Power BI Apps for Inventory; Demo Data for Power BI”

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.

• Page 36951 “PowerBI Reports Setup” · captioned “Power BI Reports Setup” · on Table 36951 “PowerBI Reports Setup”
• Page 37022 “Inventory Overview” · captioned “Inventory Overview (Power BI)”
• Page 37023 “Inventory by Item” · captioned “Inventory by Item (Power BI)”
• Page 37024 “Inventory by Location” · captioned “Inventory by Location (Power BI)”
• Page 37025 “Purchase and Sales Quantity” · captioned “Purchase and Sales Quantity (Power BI)”
• Page 37026 “Item Availability” · captioned “Item Availability (Power BI)”
• Page 37027 “Gross Requirement” · captioned “Gross Requirement (Power BI)”
• Page 37028 “Scheduled Receipt” · captioned “Scheduled Receipt (Power BI)”
• Page 37029 “Inventory by Lot” · captioned “Inventory by Lot (Power BI)”
• Page 37030 “Inventory by Serial No.” · captioned “Inventory by Serial No. (Power BI)”
• Page 37031 “PowerBI Bin Contents” · captioned “Bin Contents (Power BI)”
• Page 37032 “Bin Contents by Item Tracking” · captioned “Bin Contents by Item Tracking (Power BI)”
• Page 37064 “Inventory Report” · captioned “Inventory Report (Power BI)”
• Page 37110 “Inventory Forecasting” · captioned “Inventory Forecasting (Power BI)”
• Page 37111 “PowerBI ABC Analysis” · captioned “ABC Analysis (Power BI)”

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