Resources
Out-of-the-box Power BI Reports
Overview of standard Microsoft and NAVBI report coverage, including BC2Fab implementation details.
Out-of-the-box Power BI Reports
BC2Fab provides the data foundation for standard Power BI report apps from Microsoft, along with advanced reports from NAVBI by Navida. More than 70 reports are available across 8 functional areas, including support for multi-company reporting, Fabric connectivity, and extensibility.
🏢 Multi-Company
🗄️ Fabric Data Source
🧩 Combine & Extend
Additional capabilities
This section summarizes additional capabilities available across the functional areas for Business Central reporting.
🏢 Multi-Company Reporting
One view across all entities
- Consolidated dashboards across multiple BC companies
- Side-by-side company comparison
- Unified KPIs with entity-level drill-down
- Single source of truth for group reporting
🗄️ Microsoft Fabric Data Source
Enterprise-grade data platform
- Connect reports directly to Fabric lakehouse / warehouse
- Leverage Fabric's scalable compute & storage
- Real-time and batch data refresh options
- Central governed data layer for all reporting
- OneLake integration for seamless data sharing
🧩 Combine & Extend Data Sources
Limitless customization
- Blend BC data with external sources (CRM, web, files)
- Add custom fields or tables from BC extensions
- Enrich reports with industry-specific KPIs
- Custom calculated columns & measures
- Extend the data model without modifying standard
Functional Areas at a Glance
Power BI apps are available for the following functional areas. The implementations below include support for multi-company, Fabric-based, and extensible data models.
Finance15
- Financial Overview
- Income Statement
- Balance Sheet
- Budget Comparison
- Liquidity KPIs
- Profitability
+9 more reports
Sales18
- Sales Overview
- Daily Sales
- Moving Average
- Sales by Item / Customer
- Period-Over-Period Growth
- Sales Forecasting
+12 more reports
Sales Advanced12
NAVBI — Navida
- Sales Dashboard
- Order Intake Analysis
- Revenue Forecast
- Contribution Margin
- New vs Existing Customers
- Price Development
+6 more reports
Purchasing16
- Purchases Overview
- Daily Purchases
- Purchases by Vendor / Item
- Moving Annual Total
- Actual vs Budget
- Vendor Quality Analysis
+10 more reports
Inventory11
- Inventory Overview
- Inventory by Item / Location
- Purchase & Sales Qty
- Item Availability
- Gross Requirement
- Inventory by Lot / Serial No.
+5 more reports
Inventory Valuation3
- Valuation Overview
- Valuation by Item
- Valuation by Location
Projects8
- Project Overview
- Project Tasks
- Project Profitability
- Project Realization
- Performance to Budget
- Invoiced Sales by Type
+2 more reports
Manufacturing17
- Current / Historical Utilization
- Work / Machine Center Load
- Allocated Hours
- Capacity / Consumption Variance
- Production Scrap
- Prod Order Routing Gantt
+11 more reports
Finance & Sales — Report Details
Finance App (15 reports)
| Report | Description |
|---|---|
| Financial Overview | Snapshot of financial health & KPIs |
| Income Statement | Monthly comparison of income accounts |
| Balance Sheet | Monthly balance sheet tracking |
| Budget Comparison | G/L budgets vs actuals |
| Liquidity KPIs | Current, quick & cash ratios |
| Profitability | Gross/net profit margins over time |
| EBITDA | EBITDA & EBIT profitability metrics |
| Liabilities | Liability balances, debt ratio & debt-to-equity |
| Avg Collection Period | Days to collect receivables |
| Aged Receivables | Customer balance aging buckets |
| Aged Payables | Vendor balance aging buckets |
| G/L Entries | Detailed ledger with 8 shortcut dimensions |
| Vendor Ledger Entries | Entries posted to vendor sub-ledger |
| Customer Ledger Entries | Entries posted to customer sub-ledger |
| Late Payments | Impact of late-paying customers |
Sales App (18 reports)
| Report | Description |
|---|---|
| Sales Overview | Key sales figures & summaries |
| Daily Sales | Weekday heatmaps & patterns |
| Moving Average | 30-day trend smoothing |
| Moving Annual Total | Rolling 12-month totals |
| Period-Over-Period | YoY / QoQ / MoM comparisons |
| Month-To-Date | Accumulating sales for desired period |
| Sales by Item | Item-level metrics & % of total |
| Sales by Customer | Customer metrics & profitability |
| Sales by Salesperson | Individual performance tracking |
| Sales by Location | Location-level analysis |
| Actual vs Budget | Target variance analysis |
| Opportunity Overview | Pipeline & sales cycles |
| Sales Quote Overview | Prospective customer quote activity |
| Return Order Overview | Return rate & key metrics |
| Sales Demographics | Performance across demographic segments |
| Sales Decomposition | Contributing factors to sales figures |
| Key Sales Influencers | Most impactful variables & trends |
| Sales Forecasting | Projected sales insights |
Sales Advanced — NAVBI by Navida
In-depth sales analytics with AI-driven root cause analysis, change driver decomposition, geographic mapping, and full Business Central dimension integration.
Analysis Capabilities
| Feature | Description |
|---|---|
| Classic Dashboarding | Key metrics in comprehensible calculation schemes |
| Dynamic Multi-Dim | Freely selectable attributes with complete drilldown |
| BC Dimensions | Full integration of all Business Central dimensions |
| AI Root Cause | Analysis trees for intuitive investigation |
| Change Drivers | Quantity, price & mix effects on revenue / margin |
| Geographic Analysis | KPIs on maps for regional focal points |
| Correlation Analysis | Identify relationships between variables |
| Trend Identification | Small multiples for spotting outliers & trends |
Key Metrics Available
| Metric | Description |
|---|---|
| Order Intake | Track incoming orders over time |
| Revenue | Actual revenue with period comparisons |
| Revenue Forecast | Projected revenue based on pipeline |
| Direct Costs | Cost of goods sold tracking |
| Contribution Margin | Margin analysis per dimension |
| Discount Analysis | Discount volumes and impact |
| New Customer Revenue | Revenue from new vs existing customers |
| Price Development | Price trends across items & customers |
| Blanket Order Value | Value of framework agreements |
| Multi-Company | Consolidated or separate by entity |
Purchasing, Inventory, Projects & Manufacturing
Complete report listings for the remaining four functional areas.
Purchasing
16 reports
- Purchases Overview
- Purchase Decomposition
- Daily Purchases
- Moving Averages
- Moving Annual Total
- Period-Over-Period
- Year-Over-Year
- Purchases by Item
- Purchases by Vendor
- Purchases by Purchaser
- Purchases by Location
- Actual vs Budget
+4 more reports
Inventory
11 reports
- Inventory Overview
- Inventory by Item
- Inventory by Location
- Purchase & Sales Qty
- Item Availability
- Gross Requirement
- Scheduled Receipt
- Inventory by Lot
- Inventory by Serial No.
- Bin Contents
- Bin by Item Tracking
Projects
8 reports
- Project Overview
- Project Tasks
- Project Profitability
- Project Realization
- Performance to Budget
- Invoiced Sales by Type
- Invoiced by Customer
- Project Timeline
Manufacturing
17 reports
- Current Utilization
- Historical Utilization
- Work Center Load
- Machine Center Load
- Allocated Hours
- Expected Capacity Need
- Finished Prod Breakdown
- Consumption Variance
- Capacity Variance
- Avg Production Times
- Released Prod Orders
- Production Scrap
+5 more reports