Skip to content
E
ERPResearch
D365
★★★ strong

Microsoft Dynamics 365 Business Intelligence

Microsoft Dynamics 365 confirms 12 of the 28 business intelligence capabilities we track, with a further 10 partially covered. Its deepest coverage is in Self-Service Analytics; it is thinnest on Distribution & Access.

Business Intelligence is a core strength for Microsoft Dynamics 365 — a primary capability included in standard deployments. The product is best suited to mid-to-large companies in the microsoft ecosystem.

12of 28
Capabilities confirmed
368
Documented features
Self-Service Analytics
Strongest area
Distribution & Access
Thinnest area
Capability coverage12 of 28 confirmed

How Microsoft Dynamics 365 scores against the 28 business intelligence capabilities we track across every ERP in our catalogue.

  • Self-Service Analytics5 of 7
  • Advanced Analytics3 of 7
  • Financial Reporting2 of 7
  • Distribution & Access2 of 7
Confirmed (12)Partial (10)Not documented (6)

“Not documented” means our research has not confirmed the capability either way — it is not a finding that Microsoft Dynamics 365 lacks it. Coverage is scored against one shared capability list, so it is comparable between products.

What’s in it368 documented capabilities

The business intelligence scope Microsoft Dynamics 365 ships, grouped as the product itself organises it.

Financial analytics122

Gathers, analyzes, and shares financial data for business intelligence, spanning Power BI finance apps, configurable financial reporting, and a large library of built-in finance and analysis reports.

Highlights
  • Handling finance reporting across business units or legal entitiesCombines general ledger entries from two or more subsidiary companies into one consolidated reporting entity.
  • Power BI finance appDelivers a ready-made Power BI app with finance analytics for stakeholders across the organization.
  • Financial OverviewSummarizes overall finance activity in a single Power BI report for a quick organizational snapshot.
  • Income StatementCharts month-by-month net change across all income statement accounts.
  • Balance SheetTracks month-end balances for every balance sheet account over time.
All 121 capabilities
Capabilities 150
  • Handling finance reporting across business units or legal entitiesCombines general ledger entries from two or more subsidiary companies into one consolidated reporting entity.
  • Power BI finance appDelivers a ready-made Power BI app with finance analytics for stakeholders across the organization.
  • Financial OverviewSummarizes overall finance activity in a single Power BI report for a quick organizational snapshot.
  • Income StatementCharts month-by-month net change across all income statement accounts.
  • Balance SheetTracks month-end balances for every balance sheet account over time.
  • Budget ComparisonCompares actual G/L amounts against budgeted amounts on a monthly basis.
  • Liquidity KPIsMeasures liquidity metrics that gauge whether the organization can cover its current liabilities.
  • ProfitabilityTracks gross and net profit trends over time.
  • LiabilitiesBreaks down total liabilities into current, payroll, and long-term categories.
  • EBITDATracks EBIT and EBITDA trends for the company over time.
  • Average Collection PeriodCalculates how many days on average it takes to collect payment on outstanding receivables.
  • Aged Receivables (Back Dating)Groups outstanding customer invoices into aging buckets by payment terms, as of a chosen back-dated point.
  • Late Payments (Receivables)Highlights patterns in customer late-payment behavior.
  • Aged Payables (Back Dating)Groups outstanding vendor invoices into aging buckets by payment terms, as of a chosen back-dated point.
  • General Ledger EntriesProvides a transaction-level view of individual general ledger entries.
  • Detailed Vendor Ledger EntriesShows detailed vendor ledger transactions enriched with related vendor ledger entry information.
  • Detailed Customer Ledger EntriesShows detailed customer ledger transactions enriched with related customer ledger entry information.
  • Finance semantic modelDocuments the tables and fields behind the Power BI finance semantic model used for reporting.
  • Finance KPI overviewLists all KPIs and measures available in the Power BI finance semantic model.
  • Primary capabilities of financial reportingSummarizes the core capabilities available within financial reporting.
  • Prepare financial reportingCreates tailored views and outputs for evaluating how the business is performing financially.
  • Organize report data using account categoriesGroups general ledger accounts into categories to structure financial reports.
  • Report selection for finance reportsAssigns which report templates generate core statements such as retained earnings, the income statement, and the balance sheet.
  • View a financial reportDisplays financial reports on-screen or exports them as a PDF or Excel file.
  • Analyze data for some or all values of a dimensionSets up dimension perspectives so a single financial report can analyze every value of a dimension at once.
  • Integrate financial reports with ExcelConnects financial reporting directly with Excel for further analysis.
  • Design your own financial reportsBuilds fully custom financial report layouts and structures.
  • Row definitions in financial reportingDefines how rows are structured within a custom financial report.
  • Column definitions in financial reportingDefines how columns are structured within a custom financial report.
  • Analyze data with statistical accountsUses statistical accounts as an additional data source for financial analysis.
  • Analyze data by dimensionsAnalyzes business data across dimensions such as department or project for deeper insight.
  • Audit changes to financial reportingTracks changes users make to financial report definitions over time.
  • Financial reporting FAQAnswers common questions about the financial reporting feature.
  • Ad-hoc analysis on finance dataUses an interactive data analysis mode to explore finance data on the fly.
  • Analyze finance data from the Chart of AccountsAnalyzes finance data starting from the chart of accounts, general ledger, and account categories.
  • Analyze actual amounts versus budgeted amountsCompares actual financial results against budgeted amounts to support company-wide analysis.
  • Analyze cash flowCharts cash cycle, income and expense, and forecasted cash flow to visualize money moving in and out of the business.
  • Analyze your payment practicesGenerates a payment practices report covering both vendors and customers.
  • Finance report overviewSurfaces every out-of-the-box report available within the finance module.
  • Chart of AccountsLists every G/L account with its type, balance, and category to manage the ledger structure.
  • G/L RegisterLists each posted G/L batch, along with its entry number, posting date, and the user who created it, for audit traceability.
  • Detail Trial BalanceReconciles period-end general ledger balances by showing opening balance, transactions, and closing balance per G/L account.
  • Receivables-PayablesCompares customer and vendor balances side by side against the corresponding general ledger control accounts, flagging any mismatch.
  • Trial Balance ExcelExports a point-in-time trial balance snapshot to Excel for checking debit, credit, and closing balances.
  • Trial Balance (legacy)Shows a point-in-time snapshot of debit, credit, and closing balances across the chart of accounts.
  • Trial Balance/Previous YearCompares current trial balance figures against the same period a year earlier.
  • Trial Balance/Budget ExcelExports a trial balance snapshot to Excel, compared against budgeted figures.
  • Trial Balance/Budget (legacy)Compares trial balance figures against budgeted amounts.
  • Trial Balance by PeriodBreaks down closing balances across 12 accounting periods for every general ledger account.
  • Closing Trial BalanceCompares year-end figures, excluding closing entries, against the prior year.
Capabilities 51100
  • Fiscal Year BalanceReviews opening and closing balances per account for a chosen fiscal year to support year-end closing and trend analysis.
  • Balance Comp. - Prev. YearCompares account balances across two fiscal years side by side to surface trends and variances.
  • Foreign Currency BalanceDisplays balances for G/L, customer, and vendor accounts side by side in local currency and the original foreign currency, useful when monitoring revaluations.
  • Financial ReportProvides a configurable view of the chart of accounts for common statements like balance sheets and income statements.
  • Dimensions - TotalCalculates general ledger balance totals for chosen combinations of dimension values.
  • Dimensions - DetailBreaks general ledger activity down entry by entry for each dimension combination.
  • Dimension Check Value PostingConfirms that value entries, like those from inventory or cost transactions, post correctly to the general ledger.
  • Reconcile Cust. and Vend. AccsFinds discrepancies between the general ledger and customer or vendor subledgers.
  • Balance SheetSummarizes assets, liabilities, and equity in a standard balance sheet.
  • Income StatementPresents a standard income statement covering revenue, COGS, gross margin, operating expenses, and the bottom-line net result.
  • Statement of CashflowsSummarizes operating, investing, and financing activity in a standard cash flow statement.
  • Retained Earnings StatementShows how retained earnings move across a period: opening balance, net income earned, and any distributions paid to shareholders.
  • Audit TrailProvides a compliance-ready record of G/L activity, showing who created or reversed each entry and when.
  • Day Book Customer Ledger EntryLists customer postings chronologically, functioning as a daily sales day book.
  • Day Book Vendor Ledger EntryLists vendor postings chronologically, functioning as a daily vendor day book.
  • G/L Deferral SummaryRolls up how deferred income and cost postings move through G/L accounts over time, to help reconcile deferral balances.
  • Sales Deferral SummaryTracks how deferred sales revenue is recognized across accounting periods.
  • Purchasing Deferral SummaryShows purchasing deferral schedules to confirm expenses are spread across the correct periods.
  • G/L - VAT ReconciliationReconciles VAT amounts in the general ledger against VAT entries ahead of tax filing.
  • VAT StatementCalculates VAT due or refundable and formats it for filing with tax authorities.
  • VAT RegisterLists every posted VAT entry from sales, purchase, and journal transactions for review.
  • VAT- VIES Declaration Tax AuthPrepares an intra-EU sales declaration for the VIES system to support cross-border VAT compliance.
  • Calc. and Post VAT SettlementCalculates period-end VAT and posts the settlement journal automatically.
  • VAT ExceptionsFlags transactions where VAT should have applied but wasn't calculated or posted.
  • VAT Registration No. CheckCross-checks customer and vendor tax ID numbers with the EU's VIES lookup service.
  • VAT Reconciliation ReportCompares VAT calculated on documents against the amounts posted to VAT G/L accounts.
  • Day Book VAT EntryPresents every VAT entry in date order, formatted like a chronological register for review.
  • Consolidated Trial Balance ExcelExports a consolidated trial balance snapshot across companies to Excel.
  • Consolidated Trial BalanceCombines financial data from multiple companies so finance teams can analyze consolidated performance.
  • Consolidated Trial Balance (4)Displays combined general ledger figures for as many as four business units, laid out side by side in columns.
  • Intercompany TransactionsCompiles every posted transaction (sales, purchases, and journal postings) exchanged between related companies for reconciliation.
  • G/L Consolidation Eliminations (for IC)Eliminates internal transactions between entities so consolidated statements aren't double-counted.
  • Cost Acctg. Stmt. per PeriodShows cost activity grouped into periods such as months or quarters.
  • Cost Types DetailsBreaks down costs by type, including labor, materials, and overhead.
  • Cost Acctg. StatementSummarizes cost entries across dimensions like department or cost center.
  • Cost Acctg. AnalysisCompares actual cost values against expected or budgeted figures.
  • Cost Acctg. JournalReviews posted cost journal entries to confirm they were recorded correctly.
  • Cost AllocationsShows how costs were distributed across cost centers using defined allocation rules.
  • Cost Acctg. Statement/BudgetCompares cost center statements to budgeted amounts, showing variance in both amount and percentage.
  • Cost Acctg. Balance/BudgetCompares cost account balances with budgeted figures to inform financial planning decisions.
  • Fixed assets reportsLists the standard reports available for tracking and managing fixed assets.
  • Accounts payable analytics overviewLists the analytics options available for monitoring accounts payable.
  • Aged Accounts Payable ExcelExports period-end vendor balances to Excel to verify what's owed to vendors.
  • Vendor - Top 10 List ExcelRanks vendors by cash flow impact in Excel to help prioritize payments.
  • Vendor - Detail Trial BalanceReconciles vendor balances at period end in detail.
  • Vendor - Order SummarySummarizes outstanding purchase orders to forecast expected purchase volume.
  • Vendor - Order DetailDetails outstanding purchase orders broken down by vendor.
  • Purchase statisticsTracks vendor performance to help confirm the company is getting good value.
  • Vendor/Item PurchasesAnalyzes item purchases by vendor to manage procurement and supply chain decisions.
  • Vendor Pre-Payment JournalChecks vendor prepayment amounts before a payment file is created and the journal gets posted.
Capabilities 101121
  • Vendor - Balance to DateTracks outstanding payables by vendor as of a chosen date.
  • Vendor - Trial BalanceTies the vendor subledger back to its payables control account when closing a period.
  • Accounts receivable analytics overviewLists the analytics options available for monitoring accounts receivable.
  • Aged Accounts Receivables ExcelExports period-end customer balances to Excel to gauge collectability of outstanding debts.
  • Customer Top List ExcelRanks customers by transaction volume in Excel to spot sales trends and manage collections.
  • Customer ListLists basic customer information in one overview.
  • Customer - Detail Trial BalanceVerifies that all entries for a given customer are properly accounted for in the ledger.
  • Customer - Order SummarySummarizes unshipped orders to forecast expected sales volume.
  • Customer - Order DetailDetails outstanding sales orders by customer, highlighting overdue back orders against planned shipment dates.
  • Sales StatisticsBreaks down earnings for a single customer, or surfaces broader earnings trends across the book.
  • Customer/Item SalesAnalyzes item sales by customer to spot trends and inform inventory and marketing decisions.
  • Customer - Balance to DateShows a detailed customer balance as of a chosen closing date, such as period-end or year-end.
  • Customer - Detail Trial Bal.Reconciles customer balances at period end by showing opening balance, transactions, and closing balance per customer.
  • Customer - Payment ReceiptDisplays payment receipts for each recorded customer payment entry.
  • Customer StatementSends customers a statement of outstanding amounts that also serves as an overdue payment reminder.
  • Finance Excel reports (obsolete)Opens financial statements directly in Excel for further analysis (a legacy option).
  • Customer - Top 10 List (legacy)Ranks the highest-transaction-volume customers within a period to spot sales trends and manage collections.
  • Aged Accounts Receivables (Legacy)Analyzes period-end customer balances to gauge how collectable outstanding debts are (legacy version).
  • Vendor - List (legacy)Maintains basic vendor record information (legacy version).
  • Vendor - Summary Aging (legacy)An older aged-payables report kept for legacy compatibility; the newer Aged Accounts Payable report replaces it.
  • Aged Accounts PayableMonitors unpaid vendor invoices at period end to help prioritize overdue payments.

Will Microsoft Dynamics 365 meet your financial analytics needs? Build your requirements and perform a full analysis.

Build my requirements →
Sales analytics46

Consolidates sales data into Power BI dashboards, standard reports, and ad-hoc analysis so sales managers can track performance, customers, and pipeline for better decisions.

Highlights
  • Power BI Sales appDelivers a suite of Power BI dashboards covering sales performance for users at every level of the business.
  • Sales app overviewSummarizes overall sales activity at a glance, giving leadership a quick read on how the business is selling.
  • Key Sales InfluencersPinpoints the factors with the greatest impact on sales results and highlights trends drawn from historical sales data.
  • Sales DecompositionBreaks total sales figures down into their contributing components so managers can see exactly what drives the numbers.
  • Sales ForecastingProjects future sales performance from historical trends to support planning and target setting.
All 45 capabilities
  • Power BI Sales appDelivers a suite of Power BI dashboards covering sales performance for users at every level of the business.
  • Sales app overviewSummarizes overall sales activity at a glance, giving leadership a quick read on how the business is selling.
  • Key Sales InfluencersPinpoints the factors with the greatest impact on sales results and highlights trends drawn from historical sales data.
  • Sales DecompositionBreaks total sales figures down into their contributing components so managers can see exactly what drives the numbers.
  • Sales ForecastingProjects future sales performance from historical trends to support planning and target setting.
  • Actual vs. BudgetCompares realized sales amounts and quantities against budgeted figures to show where performance is ahead of or behind plan.
  • Daily SalesShows day-by-day sales activity so teams can spot spikes, dips, and weekly patterns.
  • Moving AverageCharts average sales across a rolling 30-day window to smooth out short-term fluctuations.
  • Moving Annual Total (MAT)Tracks cumulative sales for the trailing 12 months as a rolling annual performance figure.
  • Period-Over-Period GrowthMeasures how sales grow or contract between comparable periods to reveal momentum over time.
  • Month-To-Date (MTD)Monitors sales revenue accumulated so far in the current month against expectations.
  • Opportunity OverviewPresents open sales opportunities with counts, estimated values, sales cycle length, and potential value by location.
  • Sales Quote OverviewDetails quoting activity so managers can see volumes and values of outstanding sales quotes.
  • Return Order OverviewAnalyzes sales return orders and quantifies their financial impact on the business.
  • Sales by CustomerProfiles customers and their buying activity to show where revenue comes from.
  • Sales by ItemShows which products sell best by breaking sales down per item.
  • Sales by LocationSplits sales performance across locations to compare how each site contributes.
  • Sales by ProjectsViews sales results by project, showing how each engagement contributes to revenue.
  • Sales by SalespersonCompares revenue generated by each salesperson to gauge individual performance.
  • Sales DemographicsSegments sales results across demographic groups to reveal customer behavior patterns and sharpen sales strategy.
  • Customer Retention OverviewTracks retention metrics that show how well the business keeps its customers over time.
  • Customer Retention HistoryCharts retention rates historically so customer loyalty trends can be analyzed period by period.
  • Sales semantic modelDocuments the tables and fields behind the Power BI Sales app for report builders and analysts.
  • KPIs and measures in the Power BI Sales appCatalogs every KPI and measure available in the Sales app's Power BI semantic model.
  • Create sales analysis reportsBuilds custom analysis reports and templates covering sales, purchasing, and inventory figures.
  • Ad-hoc analysis of sales dataLets users slice and pivot sales data on the fly in data analysis mode, without building a report.
  • Sales report overviewLists the standard sales reports and analytics shipped with Business Central and what each covers.
  • Customer Top List ExcelExports the customers with the highest transaction volumes to Excel for trend spotting and collections work.
  • Customer - Order SummarySummarizes unshipped orders so expected monthly sales revenue can be forecast.
  • Customer - Order DetailDetails outstanding orders per customer and flags overdue back orders against planned shipment dates.
  • Customer/Item SalesCross-references item sales per customer, including the interplay of discounts, revenue, and volumes.
  • Salesperson - Sales StatisticsEvaluates revenue, margin, and discount impact per salesperson to compare individual profitability.
  • Salesperson - CommissionCalculates commission figures per salesperson from their documents, sales values, and profit contributions.
  • Customer - Balance to dateReports each selected customer's outstanding balance as of a chosen date, such as a period or fiscal year end.
  • Customer - Trial BalanceReconciles customer accounts with opening figures, in-period transactions, and closing totals grouped per customer.
  • Aged Accounts Receivables ExcelAges customer balances by period in Excel to gauge how collectable outstanding debts are.
  • Day Book Customer Ledger EntryLists customer postings chronologically, day by day, in the style of a sales day book for audit review.
  • Inventory Order DetailsExamines open sales orders per item and highlights back orders running past planned shipment dates.
  • Inventory Sales Back OrdersFlags sales orders that cannot ship because items are out of stock.
  • Inventory Picking ListShows which open sales orders a warehouse pick will satisfy when items are collected.
  • Customer ListProvides a reference listing of core details for every customer.
  • Customer - Top 10 list (legacy)Identifies the highest-transaction customers in a period for trend analysis and receivables follow-up.
  • Sales StatisticsAnalyzes earnings per customer and how profitability trends over time.
  • Customer - Sales listSummarizes sales by customer over a chosen period, formatted for customs and tax authority reporting.
  • Sales Reservation AvailabilityVerifies which items can fulfill open sales orders and confirms inventory reservations are correct.

Will Microsoft Dynamics 365 meet your sales analytics needs? Build your requirements and perform a full analysis.

Build my requirements →
Purchasing analytics41

Monitors purchasing KPIs through a Power BI app, standard reports, and ad-hoc analysis, covering vendors, spend, and payables.

Highlights
  • Power BI purchasing appSupplies Power BI purchasing analytics for stakeholders throughout the organization.
  • Purchases OverviewGives a top-level view of purchasing activity across the business.
  • Purchases DecompositionBreaks total purchase spend down by category, vendor, fiscal period, and document type.
  • Key Purchase InfluencersReveals the variables with the greatest effect on purchasing performance, based on purchase history.
  • Purchase ForecastingPredicts future buying trends to help anticipate supply chain needs.
All 40 capabilities
  • Power BI purchasing appSupplies Power BI purchasing analytics for stakeholders throughout the organization.
  • Purchases OverviewGives a top-level view of purchasing activity across the business.
  • Purchases DecompositionBreaks total purchase spend down by category, vendor, fiscal period, and document type.
  • Key Purchase InfluencersReveals the variables with the greatest effect on purchasing performance, based on purchase history.
  • Purchase ForecastingPredicts future buying trends to help anticipate supply chain needs.
  • Vendor Quality AnalysisEvaluates supplier performance and quality scores to inform sourcing decisions.
  • Purchases Quote OverviewReviews outstanding purchase quotes across the organization.
  • Daily PurchasesTracks purchasing activity on a day-by-day basis.
  • Moving AveragesShows average purchase values over a rolling 30-day window.
  • Moving Annual TotalTotals purchases across the trailing 12 months as a rolling annual figure.
  • Period-Over-PeriodCompares purchasing performance between periods to show the direction of travel.
  • Year-Over-YearBenchmarks purchasing spend against prior years to track long-term spending trends.
  • Purchases by ItemBreaks purchase volumes and values down per item.
  • Purchases by VendorSummarizes buying activity for each vendor.
  • Purchases by PurchaserDetails purchasing activity attributed to each purchaser.
  • Purchases by LocationCompares purchasing activity across company locations.
  • Actual vs BudgetContrasts actual purchase amounts and quantities with budgeted figures.
  • Purchases Return OverviewSurveys purchase returns across the organization.
  • Purchases semantic modelDocuments the fact tables, dimension tables, and exposed fields underlying the Purchases Power BI app.
  • Purchases KPI overviewLists every KPI and measure available in the Purchases app for Power BI.
  • Ad-hoc analysis of purchasing dataExplores purchasing data interactively in data analysis mode, with no report building required.
  • Purchasing report overviewCatalogs the purchase reports included in the standard product.
  • Aged Accounts Payable ExcelAges vendor balances per period in Excel to validate what the business owes.
  • Vendor - Top 10 List ExcelHighlights the vendors with the biggest cash flow impact to help prioritize payments.
  • Vendor - Detail Trial BalanceReconciles vendor balances in detail at the close of a period.
  • Vendor - Order SummarySummarizes open purchase orders to project expected purchase volumes.
  • Vendor - Order DetailBreaks outstanding purchase orders down vendor by vendor.
  • Purchase statisticsMonitors vendor performance so the business can confirm it gets good value for its spend.
  • Vendor/Item PurchasesAnalyzes item purchases per vendor, including how discounts relate to cost and volume.
  • Vendor Item catalogLists which vendors supply each item, or the items available from each vendor.
  • Vendor - Trial BalanceReconciles closing vendor balances against the general ledger's payables accounts at period end.
  • Day Book Vendor Ledger EntryPresents vendor postings chronologically as a daily, audit-style listing.
  • Purchase Reservation AvailabilityShows item availability for shipment tied to purchase documents like return orders.
  • Inventory Purchase OrdersReviews open purchase orders per item and flags receipts running late against expected dates.
  • Inventory Vendor PurchasesBreaks down purchases by vendor and item to sharpen procurement and supply chain planning.
  • Item/vendor catalogShares and compares vendor catalogs to support sourcing decisions.
  • Vendor - List (legacy)Maintains reference information about vendors in list form.
  • Vendor - Top 10 List (legacy)Ranks vendors by cash flow impact to guide payment prioritization.
  • Payments on Hold (legacy)Lists disputed vendor ledger entries where payment has been placed on hold.
  • Aged Accounts Payable (legacy)Ages vendor balances by period so unpaid invoices and overdue payments can be prioritized.

Will Microsoft Dynamics 365 meet your purchasing analytics needs? Build your requirements and perform a full analysis.

Build my requirements →
Inventory analytics52

Turns inventory data into insight with Power BI apps for stock and valuation, standard reports, and ad-hoc analysis for inventory managers.

Highlights
  • Power BI inventory appBundles Power BI reports that cover an organization's inventory reporting needs.
  • Inventory OverviewSummarizes the stock position across the organization at a glance.
  • Inventory ForecastingAnticipates future stock requirements from inventory trends.
  • Inventory by ItemReports stock quantities broken down by item and by item category.
  • Inventory by LocationCompares inventory levels held at each location.
All 51 capabilities
  • Power BI inventory appBundles Power BI reports that cover an organization's inventory reporting needs.
  • Inventory OverviewSummarizes the stock position across the organization at a glance.
  • Inventory ForecastingAnticipates future stock requirements from inventory trends.
  • Inventory by ItemReports stock quantities broken down by item and by item category.
  • Inventory by LocationCompares inventory levels held at each location.
  • Purchase and Sales QuantityContrasts quantities bought and sold across the organization.
  • Item AvailabilityReports current availability for every item.
  • Gross RequirementReviews all outbound transactions to compute how much of each item is needed.
  • Scheduled ReceiptLists inbound inventory broken down by document type.
  • Inventory by LotSplits total stock holdings by lot number.
  • Inventory by Serial No.Breaks total inventory down by serial number.
  • Bin ContentsReports what each warehouse bin holds, per location.
  • Bin Contents by Item TrackingShows what each bin holds along with lot and serial number detail.
  • ABC AnalysisSplits products into three sales-value tiers, A, B, and C, to guide purchasing and replenishment priorities.
  • Inventory semantic modelExplains how the Inventory Power BI app structures stock, procurement, demand, warehouse, and item-attribute data.
  • Inventory KPIsDefines every KPI and measure used across the inventory reports.
  • Power BI inventory valuation appProvides a dedicated Power BI app for inventory valuation reporting.
  • Inventory Valuation OverviewValues on-hand items location by location for a valuation summary.
  • Inventory Valuation by ItemReports inventory value broken down item by item.
  • Inventory Valuation by LocationDetails the value of inventory held at each location.
  • Inventory Valuation KPIsDocuments the KPIs and measures behind the inventory valuation reports.
  • Ad-hoc analysis of inventory dataInterrogates inventory data interactively using data analysis mode.
  • Inventory and warehouse report overviewSurveys the built-in stock and warehouse reporting and analysis tools included by default.
  • Inventory - Transaction DetailAudits every inventory movement — sales, purchases, transfers — behind current on-hand quantities.
  • Inventory AvailabilityProjects current and future availability per item or SKU, exposing shortages and surpluses from supply and demand.
  • StatusMonitors the live state of inventory operations to optimize supply chain processes and trim carrying costs.
  • Inventory Order DetailsAnalyzes open sales orders per item, flagging back orders past their planned ship dates.
  • Inventory Purchase OrdersTracks outstanding purchase orders per item and highlights overdue receipts against expected dates.
  • Inventory Top 10 ListRanks the best and worst selling items by quantity and value over a chosen period.
  • Inventory Customer SalesBreaks down sales by customer and item to surface trends and the impact of discounts on volume.
  • Inventory Vendor PurchasesAnalyzes purchases by vendor and item to strengthen procurement and supply chain decisions.
  • Inventory Cost and price listReviews stock costs alongside pricing strategy in a single report.
  • Inventory Sales Back OrdersIdentifies sales orders held up by out-of-stock items.
  • Inventory Availability Plan (Excel)Delivers item and stock-keeping-unit availability overviews directly in Excel.
  • Item - ABC AnalysisRanks stock items across A, B, and C tiers by sales value to guide buying and replenishment priorities.
  • Item/Vendor CatalogCompares vendor catalogs and offerings to inform purchasing choices.
  • Inventory Picking ListMaps warehouse picks to the sales orders they will fulfill.
  • Inventory ValuationReconciles the inventory subledger with general ledger accounts and values on-hand stock for financial reporting.
  • Item SubstitutionsManages substitute items for production orders and BOMs so work continues when preferred parts are unavailable.
  • Item Charges - SpecificationBreaks out posted item charges such as freight and handling to assess added costs.
  • Item Age Composition - Quantity and Value (Excel)Ages warehouse stock by value in Excel to expose idle or slow-moving inventory.
  • Item Expiration - QuantityLocates on-hand stock that has expired or is approaching expiry.
  • Item Dimensions - DetailGroups item entries by dimension combinations and details the value entries within each group.
  • Item Dimensions - TotalTotals item entries by dimension groups with user-defined columns such as net change or balance at date.
  • Warehouse Shipment StatusTracks open source documents by location, showing what has shipped and what is still awaiting shipment.
  • Warehouse Bin ListLists warehouse bins, their configuration, and current item quantities.
  • Warehouse Adjustment BinReviews adjustment bin usage in advanced warehouse configurations.
  • Planning AvailabilitySupports inventory level management so items are on hand when needed.
  • Production ForecastForecasts item demand from historical data so production schedules align with expected sales and stock needs.
  • Inventory Availability PlanSummarizes on-hand availability for chosen products and their stock-keeping unit variants.
  • Item Age Composition - QuantityAges stock by quantity to reveal unused or slow-moving items.

Will Microsoft Dynamics 365 meet your inventory analytics needs? Build your requirements and perform a full analysis.

Build my requirements →
Relationship management analytics16

A set of built-in reports covering contacts, opportunities, campaigns, segments, and sales cycles for monitoring relationship management activity.

Highlights
  • Contact - ListLists every recorded contact along with their linked opportunities and outstanding to-dos.
  • Contact - Company SummarySummarizes a contact company's profile alongside its recent interactions and to-dos.
  • Contact - Person SummaryDisplays a single contact's profile details, plus their recent activity and to-dos.
  • Contact - Cover SheetGenerates cover sheets that can be mailed to one or more contacts.
  • Contact - LabelsPrints mailing labels showing contact names and addresses.
All 15 capabilities
  • Contact - ListLists every recorded contact along with their linked opportunities and outstanding to-dos.
  • Contact - Company SummarySummarizes a contact company's profile alongside its recent interactions and to-dos.
  • Contact - Person SummaryDisplays a single contact's profile details, plus their recent activity and to-dos.
  • Contact - Cover SheetGenerates cover sheets that can be mailed to one or more contacts.
  • Contact - LabelsPrints mailing labels showing contact names and addresses.
  • Salesperson - OpportunitiesShows which salespeople own which sales opportunities.
  • Campaign - DetailsSummarizes the details and activity tied to a specific marketing campaign.
  • Opportunity - ListLists open opportunities along with their sales-cycle stage and linked contacts and campaigns.
  • Opportunity - DetailsBreaks down the sales stages plus completed and scheduled follow-ups tied to one opportunity.
  • Sales Cycle - AnalysisSummarizes performance across defined sales cycles.
  • Segment - ContactsShows how contacts are spread across defined segments.
  • Segment - Cover SheetProduces cover sheets for mailing to a contact segment.
  • Segment - LabelsPrints address labels for contacts within a segment.
  • Questionnaire - HandoutsPrints handout copies of a profile questionnaire.
  • Questionnaire - TestDisplays test results from completed profile questionnaires.

Will Microsoft Dynamics 365 meet your relationship management analytics needs? Build your requirements and perform a full analysis.

Build my requirements →
Sustainability analytics17

A set of reports and a Power BI app covering emissions, water and waste usage, ESG compliance, and progress toward net-zero goals.

Highlights
  • Ad-hoc analysis of sustainability dataExplores sustainability data interactively using data analysis mode.
  • Built-in sustainability reportsSurveys the standard built-in sustainability reports and analytics.
  • Analyzing sustainability entries with financial reportsAnalyzes sustainability performance data using standard financial reporting views.
  • Handle external ESG compliance reportingSets up, runs, and exports ESG reports for external compliance reporting.
  • Sustainability Power BI appDelivers sustainability analytics to stakeholders across the organization via a dedicated Power BI app.
All 16 capabilities
  • Ad-hoc analysis of sustainability dataExplores sustainability data interactively using data analysis mode.
  • Built-in sustainability reportsSurveys the standard built-in sustainability reports and analytics.
  • Analyzing sustainability entries with financial reportsAnalyzes sustainability performance data using standard financial reporting views.
  • Handle external ESG compliance reportingSets up, runs, and exports ESG reports for external compliance reporting.
  • Sustainability Power BI appDelivers sustainability analytics to stakeholders across the organization via a dedicated Power BI app.
  • CO2e AnalysisDetails CO2e emissions alongside associated carbon credit purchases.
  • Co2e Decomposition TreeBreaks CO2e emission metrics into their key contributing components to explain what's driving changes.
  • Co2e Key InfluencesIdentifies the account categories and variables most responsible for rising CO2e emissions.
  • Emissions by Category and ScopeGroups emission types by account category and scope so trends stand out.
  • Journey to Net Zero CarbonTracks an organization's progress toward a net-zero carbon target.
  • Realized Emissions vs BaselineCompares current carbon emissions to a chosen baseline period to monitor trends.
  • Realized Emissions vs TargetCompares current carbon emissions against a defined target to monitor progress toward sustainability goals.
  • Social AnalysisDisplays employee data as part of the Social component of ESG reporting.
  • Water and Waste AnalysisMonitors consumption of water and waste by type, intensity, and responsibility center.
  • Sustainability semantic modelMaps the Sustainability app's Power BI tables and fields back to the underlying emissions and workforce data.
  • Power BI Sustainability app KPIs and measuresCatalogs the KPIs and measures built into the Sustainability app in Power BI.

Will Microsoft Dynamics 365 meet your sustainability analytics needs? Build your requirements and perform a full analysis.

Build my requirements →
Analysis assist3

Covers Copilot's ability to analyze list data and answer questions about it directly inside Business Central.

Capabilities
  • Analyze data in lists with CopilotUses Copilot to answer questions and surface patterns in list data.
  • Responsible AI FAQ for analysis assistDocuments the AI approach behind analysis assist, including how it works and its known limitations.

Will Microsoft Dynamics 365 meet your analysis assist needs? Build your requirements and perform a full analysis.

Build my requirements →
KPIs, dashboards, and financial reports14

Covers how businesses define and track KPIs, build financial reports, and connect Power BI dashboards to Business Central data, including installing Power BI apps, setting reporting calendars, and drilling from a visual back to its source records.

Highlights
  • Using key performance indicators (KPIs) to meet your business goalsExplains what KPIs are and how a business can apply them to track progress toward its goals.
  • Work with Power BI reportsConnects Power BI to Business Central so users can build dashboards, charts, and KPI views from their data.
  • Use Power BI semantic models with ExcelLets users connect Power BI semantic models inside Excel to build custom Business Central reports.
  • Track KPIs with Power BI metricsSurfaces business intelligence and KPI metrics pulled from Business Central through Power BI.
  • Installing Power BI apps for Business CentralWalks through installing the packaged Power BI apps built for Business Central reporting.
All 13 capabilities
  • Using key performance indicators (KPIs) to meet your business goalsExplains what KPIs are and how a business can apply them to track progress toward its goals.
  • Work with Power BI reportsConnects Power BI to Business Central so users can build dashboards, charts, and KPI views from their data.
  • Use Power BI semantic models with ExcelLets users connect Power BI semantic models inside Excel to build custom Business Central reports.
  • Track KPIs with Power BI metricsSurfaces business intelligence and KPI metrics pulled from Business Central through Power BI.
  • Installing Power BI apps for Business CentralWalks through installing the packaged Power BI apps built for Business Central reporting.
  • Configure a week-based calendar for the Power BI appsAligns Power BI semantic models to a week-based calendar so reports follow weekly periods instead of calendar dates.
  • Configure a fiscal calendar for your Power BI reportsConfigures a fiscal-year calendar for Power BI semantic models so reports match the company's own fiscal periods.
  • Configure a standard calendar for your Power BI reportsSets up a standard calendar for Power BI semantic models to align reporting periods with the regular calendar year.
  • Power BI apps/reports by functional areaLists the Power BI app landing pages available for each functional area of Business Central.
  • Use back links to explore the data behind visualsLets a user click through a Power BI chart to reach the underlying Business Central records behind it.
  • Multi-language Power BI apps for Business CentralLets users test and use Business Central's Power BI apps in more than one language.
  • Power BI apps FAQAnswers common setup and usage questions about the Power BI apps for Business Central.
  • Using Financial ReportingTurns transaction data into custom financial views for analyzing how the business is performing.

Will Microsoft Dynamics 365 meet your kpis, dashboards, and financial reports needs? Build your requirements and perform a full analysis.

Build my requirements →
Autofill (preview)3

Covers Copilot's autofill capability, which proposes values for empty fields while a user is completing a card or document.

Capabilities
  • Autofill fields with CopilotSuggests values for empty fields while someone is filling out a card or document in Business Central.
  • Responsible AI FAQ for autofillDocuments the AI behind Autofill, including how it works and its known limitations.

Will Microsoft Dynamics 365 meet your autofill (preview) needs? Build your requirements and perform a full analysis.

Build my requirements →
Ad-hoc data analysis8

Covers tools for analyzing data outside of standard reports, including sorting, searching, and filtering lists, saving personalized views, and exporting to Excel for deeper, one-off analysis.

Highlights
  • Sort, search, and filterSpeeds up working with lists by combining data search, column sorting, and filter shortcuts.
  • Search and filter FAQAnswers frequently asked questions about searching and filtering data in lists.
  • Save and personalize list viewsLets users build, save, rename, and manage their own personalized views of filtered lists.
  • Analyze page data in ExcelOpens any list page directly in Excel for deeper, offline data analysis.
  • Analyze list and query data with analysis modeProvides an interactive analysis mode for exploring list and query data.
All 7 capabilities
  • Sort, search, and filterSpeeds up working with lists by combining data search, column sorting, and filter shortcuts.
  • Search and filter FAQAnswers frequently asked questions about searching and filtering data in lists.
  • Save and personalize list viewsLets users build, save, rename, and manage their own personalized views of filtered lists.
  • Analyze page data in ExcelOpens any list page directly in Excel for deeper, offline data analysis.
  • Analyze list and query data with analysis modeProvides an interactive analysis mode for exploring list and query data.
  • Ad-hoc data analysis by functional areaOrganizes ad-hoc analysis entry points by department so teams can find relevant data views quickly.
  • Analyze report data with ExcelExports a report's underlying dataset to Excel via XML for custom, one-off analysis.

Will Microsoft Dynamics 365 meet your ad-hoc data analysis needs? Build your requirements and perform a full analysis.

Build my requirements →
Use reports in daily work9

Covers the day-to-day mechanics of running reports in Business Central: scheduling, bookmarking, printing, exporting, and configuring how each one is formatted and shared.

Highlights
  • Run reportsExplains how to launch a report on demand or add it to a queue to run at a set date and time.
  • Bookmark a reportPins a shortcut to a page or report on the role center's navigation menu for quick access.
  • Analyze report data with ExcelUses Excel and XML to dig into the dataset behind a report as part of routine reporting work.
  • Print reportsConfigures default printers for report print jobs across different scenarios.
  • Schedule reportsQueues a report to run automatically at a chosen date and time instead of running it by hand.
All 8 capabilities
  • Run reportsExplains how to launch a report on demand or add it to a queue to run at a set date and time.
  • Bookmark a reportPins a shortcut to a page or report on the role center's navigation menu for quick access.
  • Analyze report data with ExcelUses Excel and XML to dig into the dataset behind a report as part of routine reporting work.
  • Print reportsConfigures default printers for report print jobs across different scenarios.
  • Schedule reportsQueues a report to run automatically at a chosen date and time instead of running it by hand.
  • Share and export reports with the report inboxManages completed reports from a central inbox, where they can be downloaded, shared, exported, or deleted.
  • Manage saved report settingsLets an administrator predefine a report's options and filters, then roll those settings out to a single user or everyone.
  • Set the layout used by a reportChooses which layout a report uses when it's previewed or printed.

Will Microsoft Dynamics 365 meet your use reports in daily work needs? Build your requirements and perform a full analysis.

Build my requirements →
Chat with Copilot (preview)3

Covers a conversational Copilot interface for finding data and getting in-product help.

Capabilities
  • Chat with CopilotLets a user ask Copilot questions through chat to find data or get help.
  • Responsible AI FAQ for chat with CopilotDocuments the AI behind chat with Copilot, including how it works and its known limitations.

Will Microsoft Dynamics 365 meet your chat with copilot (preview) needs? Build your requirements and perform a full analysis.

Build my requirements →
Built-in reports22

Catalogs the ready-made reports available across every functional area of standard Business Central, spanning finance, sales, purchasing, inventory, projects, fixed assets, assembly, manufacturing, and service management.

Highlights
  • Prepare financial reportingBuilds different financial views and statements to analyze how the business is performing.
  • Key financial reportsLists the core financial reports included in standard Business Central.
  • Accounts receivable reportsProvides built-in reports for monitoring outstanding customer balances and receivables activity.
  • Accounts payable reportsOffers built-in analytics for tracking vendor balances and payables obligations.
  • Sustainability reportsIncludes built-in sustainability reports and analytics for tracking environmental metrics.
All 21 capabilities
  • Prepare financial reportingBuilds different financial views and statements to analyze how the business is performing.
  • Key financial reportsLists the core financial reports included in standard Business Central.
  • Accounts receivable reportsProvides built-in reports for monitoring outstanding customer balances and receivables activity.
  • Accounts payable reportsOffers built-in analytics for tracking vendor balances and payables obligations.
  • Sustainability reportsIncludes built-in sustainability reports and analytics for tracking environmental metrics.
  • Sales reportsProvides built-in sales reports and analytics for monitoring revenue and order activity.
  • Purchase reportsLists built-in purchase reports for tracking procurement activity.
  • Inventory and warehouse reportsCovers inventory and warehouse reports for tracking stock levels and movement.
  • Project reportsProvides reports for monitoring project status and costs.
  • View project usage estimatesTracks estimated versus actual consumption of items and resources on a project.
  • Monitor project progress and performanceCalculates work-in-process (WIP) value to estimate a project's financial standing while it's still active.
  • Fixed assets reportsProvides standard reports for tracking and managing a company's fixed assets.
  • Assembly Management ReportsLists assembly reports and analytics for tracking assembly operations.
  • View the Bill Of Material (BOM) structureDefines an assembly bill of materials (BOM) listing the components needed to build an assembled item.
  • Production reportsProvides built-in production reports and analytics for tracking manufacturing output.
  • View load on work and machine centersCompares workload against capacity on work and machine centers to spot bottlenecks and support finite scheduling.
  • View work center ledger entriesLogs hours that work and machine centers spend on upkeep or other jobs unrelated to production orders.
  • View service statisticsSummarizes service document activity across quotes, credit memos, invoices, orders, and service lines in one quick view.
  • Service orders overviewProvides an overview of service orders, including keeping contract and quote amounts accurate for correct annual invoicing.
  • Service quotes overviewCovers service quotes, including adjusting annual contract amounts so invoicing stays correct each year.
  • Posted service document overviewStreamlines posting of service documents to support consistent, efficient customer service.

Will Microsoft Dynamics 365 meet your built-in reports needs? Build your requirements and perform a full analysis.

Build my requirements →
Analyze data in business intelligence tools3

Covers connecting external business intelligence tools, including Microsoft Fabric and on-premises AI insights, to Business Central data for teams that skip the built-in analytics.

Capabilities
  • Microsoft Fabric and Business CentralConnects Microsoft Fabric to Business Central data for business intelligence and KPI reporting.
  • Intelligent insights (on-premises)Compares AI-driven insight options between cloud and on-premises deployments, useful when planning a move to the cloud.

Will Microsoft Dynamics 365 meet your analyze data in business intelligence tools needs? Build your requirements and perform a full analysis.

Build my requirements →
Suggest number series (preview)3

Covers Copilot's ability to suggest number series setup for new record types.

Capabilities
  • Suggest number series with CopilotRecommends number series configuration using Copilot when setting up new record types.
  • Responsible AI FAQ for suggest number series with CopilotDocuments the AI behind the number series suggestion feature.

Will Microsoft Dynamics 365 meet your suggest number series (preview) needs? Build your requirements and perform a full analysis.

Build my requirements →
Summarize (preview)3

Covers Copilot's Summarize feature, which condenses a record's data into a quick overview and flags what needs attention.

Capabilities
  • Summarize records with CopilotCondenses a record into a short overview and highlights what needs attention, using Copilot.
  • Responsible AI FAQ for summarizeDocuments the AI behind the Summarize feature, including its testing and limitations.

Will Microsoft Dynamics 365 meet your summarize (preview) needs? Build your requirements and perform a full analysis.

Build my requirements →
Other capabilities3
Capabilities
  • Import payroll transactionsImports and posts payroll transactions from an external payroll provider, such as Ceridian, into the general ledger.

Will Microsoft Dynamics 365 meet your other capabilities needs? Build your requirements and perform a full analysis.

Build my requirements →
Free PDF · Vendor-neutral · No sales calls

The Microsoft Dynamics 365 Evaluation Kit

An independent assessment of Microsoft Dynamics 365 — strengths, gaps and real pricing — plus a requirements template you can score its business intelligence against alongside every other system on your shortlist.

Microsoft Dynamics 365 Evaluation Kit

2026 Edition · PDF guide + XLSX template

ERP Research

  • Buyer's guide (PDF): Microsoft Dynamics 365 independently assessed — where it is strong, where it is not, and what it actually costs
  • Requirements template (XLSX): weight your requirements and score vendors side by side
  • Built to work with the 28 business intelligence capabilities scored on this page
  • The questions to put to the vendor and to implementation partners
Free Download

Microsoft Dynamics 365 Evaluation Kit

By submitting, you agree that ERP Research may share your details with matched ERP implementation partners, who may contact you about your enquiry. Privacy policy

Sent to your inbox in seconds. No spam, one-click unsubscribe.

Join 2,000+ companies using ERP Research to find their ideal ERP

Microsoft Dynamics 365 add-ons & integrations

Extend Microsoft Dynamics 365 with best-of-breed software that integrates with it:

Embedded analyticsSelf-service dashboards on top of your ERP data.+10 more →
NetSuite integration platforms (iPaaS)Cloud integration connecting your ERP to other SaaS.+10 more →
NetSuite master data managementGolden records for customer, vendor and product data across your ERPs.+11 more →
ETL toolsPipelines that load NetSuite, SAP and Dynamics data into your warehouse for BI.+10 more →
Financial reporting softwareReport writers and Excel-native statements built from your ERP general ledger.+10 more →
Process mining softwareEvent-log mining that exposes ERP process bottlenecks and proves the fix.+9 more →
API management softwareGateways and developer portals that govern the APIs feeding your ERP.+9 more →
ERP connectorsPre-built connectors that plug one SaaS app straight into your ERP.+11 more →
How it compares

Business Intelligence coverage across the systems most often shortlisted alongside it, scored against the same capability list.

Business Intelligence capability coverage by product, showing confirmed capabilities out of the number scored in each category.
Area
Microsoft Dynamics 365 logo
Microsoft Dynamics 365
Acumatica logo
Acumatica
IFS Applications logo
IFS Applications
SAP S/4HANA Public Cloud logo
SAP S/4HANA Public Cloud
SAP S/4HANA Private Cloud logo
SAP S/4HANA Private Cloud
Infor CloudSuite logo
Infor CloudSuite
Infor M3 logo
Infor M3
Self-Service Analytics5+1/70+5/74+1/74+2/75+1/75+1/71+2/7
Advanced Analytics3+4/73+3/74+3/72+3/7
Financial Reporting2+5/73+3/73+3/75+1/74+2/73+4/74+2/7
Distribution & Access2/72+2/70+1/72/7
ConfirmedPartialNot documented— not scored in this area

Each cell reads confirmed+partial/scored. Grey reflects capabilities our research has not confirmed either way — it is not a finding that a product lacks them.

Compare these systems side by side →

Business Intelligence — strength by vendor

VendorStrengthBest forStarting priceImplementationActions
SAP S/4HANA Public Cloud logo
SAP S/4HANA Public Cloud
★★★ strongMid-market and standardised enterprises wanting fast time-to-value$180/user/mo3–6 months
SAP S/4HANA Private Cloud logo
SAP S/4HANA Private Cloud
★★★ strongLarge, complex enterprises needing deep customisation and controlled upgradesCustom6–18 months
Oracle NetSuite logo
Oracle NetSuite
★★★ strongFast-growing mid-market companies wanting unified cloud ERP$99/user/mo4–9 months
Oracle ERP Cloud logo
Oracle ERP Cloud
★★★ strongLarge enterprises moving from on-premise Oracle to cloudCustom9–18 months
Microsoft Dynamics 365 logo
Microsoft Dynamics 365 (this page)
★★★ strongMid-to-large companies in the Microsoft ecosystem$50/user/mo6–14 months
Sage Intacct logo
Sage Intacct
★★★ strongService companies and nonprofits needing deep financial managementCustom3–6 months
Infor CloudSuite logo
Infor CloudSuite
★★★ strongLarge enterprises wanting industry-specific cloud ERPCustom9–18 months
Workday logo
Workday
★★★ strongPeople-centric organisations needing unified HR + financeCustom6–12 months

Evaluating business intelligence on Microsoft Dynamics 365

What to put in front of the vendor before you commit.

  1. 1Self-service report building (no IT dependency)
  2. 2Real-time vs batch reporting
  3. 3Integration with Power BI, Tableau, or Looker
  4. 4Embedded AI and predictive analytics
  5. 5Mobile dashboard access

Microsoft Dynamics 365 starts at $50/user/mo with a typical total cost of $150K–$1M+ and a 6–14 months implementation.

Full Microsoft Dynamics 365 pricing breakdown →

Microsoft Dynamics 365 implementation partners

Firms with proven Microsoft Dynamics 365 delivery experience — start here rather than an open RFP.

Microsoft Dynamics 365 Business Intelligence FAQ

How do you embed a Power BI report in Dynamics 365?

Power BI reports can be embedded directly into Dynamics 365 forms and dashboards using the Power BI visualization control, natively supported since both platforms run on Microsoft's cloud stack. You publish the report to a Power BI workspace, then add it as a tile or embedded visual on the relevant Dynamics 365 entity form or dashboard.

How do you integrate Power BI with Dynamics 365?

Power BI connects to Dynamics 365 through native data connectors — for Dataverse-based apps like Sales and Field Service via the Dataverse connector, and for Finance and Operations via entity store or data lake export. Once connected, Power BI can build custom reports and dashboards on live or near-real-time Dynamics 365 data without manual exports.

How do you create a dashboard in Dynamics 365?

Dashboards in Dynamics 365 are built from the app's dashboard designer, where you add charts, lists, and embedded Power BI tiles pulled from existing views and reports. Users can create personal dashboards or admins can publish system dashboards shared across a security role, without needing developer involvement for standard layouts.

How do you create reports in Dynamics 365 Finance and Operations?

Financial reports in Finance and Operations are typically built using the Financial Reporting tool, which lets finance teams design row and column report structures against the chart of accounts, or via embedded Power BI for operational reporting. Most standard financial statements come with pre-built templates that teams customise rather than build from scratch.

Other Microsoft Dynamics 365 modules

Explore Microsoft Dynamics 365 by industry & company size

Related Resources