Vena adds Microsoft Fabric connector for Dynamics 365 F&O to streamline FP&A data

Vena, an FP&A platform provider, has expanded its data integration capabilities with six new pre-built connectors for Microsoft Fabric, including a financial planning and analysis–ready connector for Microsoft Dynamics 365 Finance & Operations. 

The release is aimed at organizations that rely on D365 F&O for core financial and operational data but struggle to bring that data together with other business systems in a way that supports fast reporting and planning, according to the company.

Instead of relying on manual data exports, spreadsheets, or custom integration projects, the new connector allows data from D365 F&O to flow directly into Microsoft Fabric as the centralized data layer, where it is automatically refreshed and ready for use in Vena's reporting, modeling, budgeting, and forecasting workflows, the company said.

By using Microsoft Fabric as the shared foundation, finance teams can work from a single, consistent version of financial and operational data while continuing to use Vena's Excel-based interface for planning and analysis. Vena said that this approach aims to reduce data fragmentation and remove one of the largest bottlenecks in FP&A processes: getting accurate, timely data into the hands of decision-makers.

According to Vena, key capabilities include:

• Microsoft-native data flows: Pre-built, secure pipelines move data from D365 F&O into Microsoft Fabric and then into Vena, so finance teams don't need custom integration work or IT support to manage data flows
• Real-time reporting and planning: Because the data in Fabric refreshes automatically, Vena users always have current numbers in front of them when they're building budgets, forecasts, and financial reports.
• A foundation that grows with you: Fabric serves as the main data layer, so teams don't have to pause planning when they switch or combine ERPs. The data keeps moving, and the planning work stays on track, even during major changes.
• Works the way finance teams already do: Vena still lets teams work in Excel but adds the controls, collaboration, and workflow tools needed to support planning across the entire company.

"With Microsoft Fabric, we're giving our customers a unified, secure environment where data is always ready to inform the next decision," said Hugh Cumming, chief technology officer at Vena. "It's about enabling finance and business leaders to spend less time wrangling data and more time shaping strategy."

The integration is meant to let companies modernize their data setups without forcing finance teams to change the tools they already use. By centralizing data in Fabric and continuing to run reporting and planning in Vena, organizations can simplify data access, keep workflows steady during system changes, and set themselves up for more advanced, AI-driven forecasting and scenario planning, according to the company.