TL;DR

The 2025 Release Wave 2 for Dynamics 365 Business Central introduces enhanced Power BI sales reports: new visuals, KPIs, drill-down features, and opportunities tracking. These reports, available in AppSource, connect directly to your BC data, providing deeper insights into sales performance, budgets, and customer activity.

Introduction

I want to show you some enhanced Power BI reports that Microsoft has recently released for Dynamics 365 Business Central.

These reports were released with the 2025 Release Wave 2 (version 26.2) of Business Central. We’re going to look at a number of new sales reports, and I like these because they’re really nice-looking reports that give users access to the data they want to analyze and share.

---

Accessing the Reports

I like to view Power BI reports in PowerBI.com, but they’re also available inside Business Central. You can connect them easily to your BC data.

These reports are created by Microsoft for Business Central and are available in Microsoft AppSource for free. You will need additional licensing—TMC can help with that.

In PowerBI.com, I go to the Apps section to see all Microsoft-created apps, which can be downloaded into your BC system.

---

Sales Overview Report

In the Sales app, there are multiple reports already connected to Business Central.

• Filters on the right make it easy to narrow results.

• KPIs at the top highlight key business metrics.

• You can click a salesperson to see details such as gross profit by item and top customers.

---

Sales by Day

For businesses that need daily sales visibility, this report is very useful.

• Drill down from fiscal year to quarter to month to specific days.

• Right-click to see details for a specific sale.

• Export to Excel or PowerPoint to share with coworkers.

• Compares sales year-over-year, from 2020 to 2025.

---

Month-to-Date Sales

Shows sales growth throughout the month with:

• A customer quadrant to analyze sales by customer.

• Ability to click a customer to see related transactions.

• Combination of graphs for an at-a-glance view.

---

Sales by Item

Displays item sales over time and by item category.

• Useful for companies with dynamic inventory.

• Highlights the importance of setting up categories and dimensions properly in BC for accurate reporting.

• Drill down to see details such as credit memos.

---

Sales by Salesperson

Similar to the Sales Overview but focused on salesperson performance.

• Select a salesperson to update all charts to their data.

• Drill down to see purchases by specific customers.

• Includes opportunity drill-through for CRM-style insights.

---

Budget vs. Actual Sales

If you’re budgeting in BC (by customer or item), this report shows:

• Actual sales compared to budget.

• Ability to filter by product category and drill into details.

---

Sales Decomposition

A graphical drill-down report showing:

• Sales by location, salesperson, and customer city.

• Useful for managing territory performance.

• Again, accurate setup of BC is key for meaningful reporting.

---

Key Influencers Report

A newer report type that:

• Identifies factors influencing sales performance.

• Lets you drill into specific categories (e.g., chairs) to see how influencer metrics change.

---

Opportunity Overview

If you use BC for opportunity tracking, this report:

• Shows all opportunities in the pipeline.

• Lets you drill down by salesperson.

• Updates regularly with BC data for real-time CRM insights.

---

Conclusion

We reviewed several new and enhanced Power BI sales reports for Business Central—available at no additional cost (with the right Power BI license).

If you’re new to Power BI, it’s a great, user-friendly reporting infrastructure with easy sharing capabilities. Microsoft also plans to make report details available for customization.