Use enhanced analytics for manufacturing (updated Power BI app)

Enabled for	Public preview	General availability
Users, automatically	-	Jun 15, 2025

Business value

The improvements in reporting and analytics for the manufacturing area help your business track new key performance indicators (KPIs) and scenarios in Power BI.

Feature details

We've greatly improved reporting and analytics for manufacturing in Power BI by adding new reports:

• Work Center Statistics report shows the work center scrap percentage. It also lists work center output and work center scrap values.
• Machine Center Statistics report shows the machine center scrap percentage. It also lists machine center output and machine center scrap values.
• Prod Order List report shows total actual cost with variances to expected and standard costs. It also shows quantities, document numbers, source numbers, and production order routing number.
• Prod Order Routing Gantt report shows routing line timelines as operation durations.
• Prod Order WIP report shows WIP value over time. It also lists production order level details such as beginning balance value, consumption, capacity, output, and ending balance value.
• Production Overview report focuses on current or unfinished production orders.

We also updated some existing reports:

• Current Utilization report is deprecated.
• We're deprecating Historical Utilization.
• We updated the visual layout for Work Center Load. We added a Work Center Load Details matrix that breaks down work center statistics by work center, source number, and production order.
• We renamed Allocated Hours to Allocated Time and updated its visual layout:
  • You now see allocated time by work center, source number, work center type, and production order status.
  • The Allocated Time Details matrix shows allocated time by source number and production order.
• We updated the visual layout for Expected Capacity Need:
  • You see expected capacity need by work center, machine center, and source number.
  • The Expected Capacity Need Variance matrix shows production order expected capacity need versus production order actual capacity need, and the deviation as a percentage.
• Finished Production Order Breakdown section shows the total actual cost and variances to the expected and standard costs. Visual layout updates include:
  • A stacked bar chart that breaks down actual costs by source number, with cost components as segments.
  • A breakdown of finished production orders that shows planned and finished quantities, along with actual cost components for each production order.
• Consumption Variance section shows material cost and variances to the expected and standard material costs. Visual layout updates include:
  • Bar charts that show expected and standard material cost deviation percentages by source number.
  • A Consumption Variance Details matrix that lists actual, expected, and standard material costs, along with variances for each production order.
• Capacity Variance section shows capacity cost and variances to the expected and standard capacity costs. Visual layout updates include:
  • A bar chart that shows expected capacity cost deviation percentages by source number.
  • Capacity Variance Details matrix lists the standard and expected capacity cost variances, and the production order capacity need variance.
• Average Production Times has visual layout updates:
  • You see the average production time per finished quantity by work center and by source number.
  • Average Production Time Details matrix lists actual time used, finished quantity, and average production time per unit by source number and production order.
• Released Production Orders highlights total actual cost with variances to expected and standard costs. Visual layout updates:
  • You see the number of production orders by source number as a bar chart.
  • Completion Ratio pie chart shows the relationship between finished quantity and remaining quantity.
  • Released Production Order Details list key details about released production orders, such as starting, ending, and due dates, planned versus finished quantities, and document number, source number, and production order routing number.
• Production Scrap section highlights production order scrap percentages and lists production order finished and scrap quantities. Visual layout updates include:
  • A line chart that shows scrap quantity trends over time.
  • A central card that lists work and machine center scrap key performance indicators (KPIs).
  • A bar chart that shows scrap percentage by production order.
  • A bar chart that shows scrap quantity by scrap code.
  • A comparative bar chart that shows scrap quantity versus expected scrap quantity by source number.

In the version 26.2 update, we release the source code for the Manufacturing Power BI app.

Geographic areas

Visit the Explore Feature Geography report for Microsoft Azure areas where this feature is planned or available.

Language availability

Visit the Explore Feature Language report for information on this feature's availability.

Tell us what you think

Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.

Additional resources

learn.microsoft (docs)