AI-Accelerated Microsoft Fabric Integration for Finance Teams

Solver for Microsoft Fabric | Frequently Asked Questions

• What does the Solver Microsoft Fabric integration do?

  The integration connects Solver to data in Microsoft Fabric so finance teams can plan, report, consolidate, and analyze on the same governed data their analytics teams use. Teams build reports and budget input forms in Solver's native Excel design experience and work from one source of truth instead of exporting data into disconnected spreadsheets.

• How is Solver different from building finance reports in Power BI on Fabric?

  Power BI excels at visualizing and exploring data. Solver adds the finance processes around it: budget input forms, workflow and approvals, unlimited budget versions, financial consolidation, and formatted financial statements. Teams that prefer Power BI can keep it, since Solver supports both Excel and Power BI dashboards for analysis.

• Can Solver combine Microsoft Fabric data with other data sources?

  Yes. Solver's data warehouse supports unlimited data sources, both on-premises and cloud. Combine Fabric data with ERP, CRM, payroll, and operational systems to report on financial and operational performance together. Data is organized with common business terminology, so finance users can build reports without knowing database table names.

• Does Solver work with Business Central data in Microsoft Fabric?

  Yes. If your organization brings Dynamics 365 Business Central data into Microsoft Fabric, Solver's Microsoft Fabric connector can bring it into Solver for financial reporting, budgeting, and forecasting. Organizations not using Fabric can connect Solver directly to Business Central through Solver's QuickStart integration.

• Do I need Microsoft Fabric to use Solver?

  No. Solver connects directly to ERPs including Acumatica, Dynamics 365 Business Central, Sage Intacct, Oracle NetSuite, and SAP Business One through QuickStart integrations. Microsoft Fabric is an option for organizations that already centralize their data in OneLake and want finance planning and reporting to run on that same foundation.

• How does Solver Copilot help with Microsoft Fabric data?

  Solver Copilot brings AI into planning and reporting. The Help Agent answers product questions instantly, and the Analysis Agent identifies trends, detects anomalies, and generates charts from data in Solver, including data sourced from Microsoft Fabric. Solver Copilot is built on OpenAI GPT within Microsoft Azure, user input never trains the model, and it is available in the United States.