Be honest: how many hours a month do you (or someone on your team) spend exporting data to Excel, reformatting it, and emailing it around just so leadership can see the numbers? If the answer makes you wince a little, this post is for you.
We’ve made it to the last stop in this series. Over the last four posts we’ve walked through the future of D365 Business Central, including the connected, integrated experience covered in Post #4, “Connected Business.” Today we’re closing with the piece controllers and CFOs probably care about most: the numbers themselves, and how fast and trustworthy they’re about to get.
Microsoft’s 2026 release wave 1 brings a real set of upgrades to reporting and analytics. None of it is flashy AI magic. It’s the unglamorous, load-bearing stuff: better Power BI reports, smarter financial reporting tools, and new ways to pull data (and PDFs) out of the system automatically. Let’s dig in.
The idea in one minute 💡
The Subscription Billing Power BI app gets a visual overhaul. Financial reporting gets better authoring, distribution, and governance tools. And new read-only APIs (an API is just a way for other systems to ask Business Central for data directly) let auditors, IT, and automation tools query approval workflows, permissions, and document PDFs without digging through screens by hand. The upshot: your team spends less time assembling reports and can actually trust what’s in them once they’re built.
A better Power BI experience for subscription revenue 📊
If your organization uses Business Central’s Subscription Billing module for recurring revenue, contracts, and deferrals, you already know the built-in Power BI app is where the real analysis happens. This wave refreshes 14 of its reports, including Revenue Analysis, Churn Analysis, Revenue Forecast, and Total Contract Value Analysis, as part of the enhanced Subscription Billing Power BI app.
Expect richer visuals like KPI cards, map visuals, tree maps, scatter charts, and conditional formatting, plus better drill-back into the underlying transactions and support for fiscal calendar hierarchies (handy if your fiscal year doesn’t match the calendar year). For anyone owning recurring revenue or churn metrics, this is a genuinely useful upgrade.
Financial reporting gets more governed and more automated ✅
This is the one I think most controllers will appreciate. The financial reporting enhancements touch how reports are discovered, built, distributed, and governed:
- A new tile view on the report list shows status, category, and last-run date at a glance.
- Authors get more control: company logo on PDF output, formatting overrides, and report categories.
- Users can schedule reports for automatic distribution to groups (email or report inbox) and run reports across every dimension value at once, instead of one at a time.
- Administrators can set global formatting defaults and monitor usage through a new audit log. That’s a real help when auditors ask who ran what, and when.
That audit log matters more than it sounds. A lot of “governance” today is tribal knowledge: someone just remembers which version of the trial balance is the right one. This moves that knowledge out of people’s heads and into the system.
New APIs: less manual digging, more automated oversight ⏳
The last piece is less visible day-to-day but matters if you own controls, compliance, or IT oversight. Three new read-only APIs stand out:
- Approval workflow APIs let auditors and IT query workflow definitions, who’s mapped to what, and full action history for compliance reporting, no manual exports needed.
- Permission APIs let you query permission sets and user/security-group mappings, a real time-saver for access reviews.
- Document report PDF APIs let integrations pull PDFs of sales, purchasing, inventory, and assembly documents automatically. Think auto-archiving with no human involved.
All three are read-only and gated behind dedicated permission sets meant for auditors and IT, not everyday users. Microsoft flags them as building blocks for Power Automate and Copilot Studio integrations, meaning some of this oversight work could eventually run itself.
What this means for you
None of this requires you to change how you work today. But together, it chips away at the two biggest complaints I hear from finance teams: “I don’t trust this number” and “why does this report take three hours to build.” The governance and audit trails tackle the trust problem. The scheduling, richer visuals, and API automation tackle the time problem. Check with your partner on rollout timing for your environment. These features land between April and June 2026.
Thank you for reading!
That wraps up “The Future of D365 Business Central,” five posts on where this platform is headed, including Post #4, “Connected Business,” right before this one. Missed any? They’re all on the blog waiting for you. And if you work in D365 Finance & Supply Chain instead, I’ve got you covered too, in the companion series “The Future of D365 Finance & Supply Chain.” Thanks for following along. Here’s to numbers you can actually trust. ☕
Sources
- Business Central 2026 release wave 1 planned features
- Enhanced Subscription Billing Power BI app
- Experience financial reporting enhancements
- Use new APIs for analyzing approval workflows for auditors and IT staff
- Use new APIs for analyzing permissions for auditors and IT staff
- Use new APIs for getting the PDF of a document report
Interested in learning more? Check out some of my latest posts:
Leave a Reply