ERP systems hold a huge amount of business value. Every sale, invoice, purchase order, vendor record, budget update, stock movement and customer interaction adds to the bigger picture.
The challenge today is not collecting data. Most ERP systems already produce more than enough of it.
The real challenge is turning that data into useful answers when people need them.
This is where Model Context Protocol (MCP) is becoming an interesting direction for enterprise analytics.
Microsoft’s Dynamics 365 ERP Analytics MCP for finance and operations apps is currently in public preview. It allows AI agents to access and analyse Business performance analytics data through natural-language questions, without users needing to write DAX queries.
The bigger idea is to make business intelligence easier to use, while keeping the context, structure, and security that enterprise data needs.
Understanding MCP in ERP Analytics
The Model Context Protocol (MCP) is an open standard that helps AI applications connect with external data and tools in a structured way.
In Dynamics 365 ERP Analytics, MCP gives AI agents access to the analytical layer of Business performance analytics.
This layer includes measures, dimensions, tables, relationships and other details that help define how business information should be understood.
That context matters. If someone asks, “Which customers generated the most revenue last quarter?”, the AI needs to understand how the business defines revenue, customers and the time period being analysed.
Microsoft describes a flow in which the agent understands the user’s analytical intent, retrieves the relevant Business performance analytics schema, generates and executes DAX and returns structured insights.
In simple terms, the flow becomes:
Ask a business question → AI determines the analysis → business data is analysed → receive an answer.
From Predefined Reports to Business Questions
Traditional reports and dashboards are not going away.
They are still useful for standard reporting, regular reviews, KPIs and monitoring business operations.
But business questions are not always predictable.
A manager may start with one question, such as why revenue declined in a region and quickly move into follow-ups about products, timing, or historical trends.
A conversational approach can make this exploration more flexible.
Instead of starting with a report and trying to fit every question into it, users can start with the question itself.
MCP does not make dashboards less valuable. It simply gives users another, more flexible way to explore the analytical data behind them.
Why Business Context Matters
One of the most important ideas behind AI-powered analytics is simple: data alone is not enough.
Business performance analytics helps define relationships, measures and dimensions so AI can work with business meaning, not just numbers.
This becomes particularly important in enterprise environments, where the same data can have different meanings depending on how the organisation defines its metrics, dimensions and business processes.
Asking Better Questions Without Writing DAX
A practical benefit of ERP Analytics MCP is that business users can ask questions in plain language instead of writing DAX queries.
For example:
- “Compare vendor performance between Q1 and Q2.”
- “Show revenue trends over the last 12 months.”
- “Which products have declining sales?”
- “Which regions are contributing most to revenue?”
- “Calculate inventory turnover by product category.”
The AI agent can interpret the question and generate the required analytical query.
Microsoft identifies use cases including aggregations, trend analysis, comparisons, top and bottom performers, anomaly detection and more complex calculations.
This can make analytics more accessible to people who understand the business but may not work directly with DAX or advanced reporting tools.
The real value is being able to ask business questions and receive analysis based on the organisation’s actual analytical model.
Security Cannot Be an Afterthought
Making ERP information accessible to AI also creates an important question:
Who should be allowed to see the information?
ERP analytics can include sensitive financial, customer, supplier and operational information, so an AI-powered interface cannot give unrestricted access to everything.
Microsoft states that ERP Analytics MCP enforces row-level security based on authenticated user roles, helping users access only the data they are authorised to see.
For organisations evaluating AI-powered ERP analytics, security and governance must be considered alongside functionality, not after it.
From Insight to Action
MCP becomes even more useful when analytics connects with business processes.
Microsoft documents that ERP Analytics MCP can work alongside the Dynamics 365 ERP MCP server, allowing analytical insights to be combined with transactional actions and broader agent workflows.
For example, a procurement manager could identify vendors with declining delivery performance, check which purchase orders may be affected and decide what action to take next.
Data → Analysis → Insight → Business Action
The bigger opportunity is to make intelligence a natural part of how employees investigate problems, evaluate options and make decisions.
What Could This Mean for Business Teams?
Different teams can use ERP analytics in different ways.
For finance teams, conversational analytics could help investigate revenue, expenses, budgets, profitability, receivables and financial trends.
For procurement teams, it could help explore vendor performance, purchasing patterns, supplier trends and purchase orders.
For operations teams, it could support questions around inventory, product performance, orders and operational trends.
The value will depend on the organisation’s Business performance analytics setup, data quality, analytical model, permissions and business needs.
MCP isn’t valuable simply because it uses AI.
It becomes valuable when it helps people answer meaningful business questions faster and use those insights in real decisions.
MCP Doesn’t Make Bad Data Good
Businesses should also remember one simple point:
AI cannot compensate for unreliable business data.
If customer records are inconsistent, metrics are unclear, information is incomplete, or permissions are poorly set up, an AI interface will not automatically fix the problem.
Before introducing AI-powered analytics, organisations should consider:
- Is the underlying business data accurate and consistent?
- Are important business metrics clearly defined?
- Are user roles and access boundaries properly configured?
- Is the analytical model structured for meaningful analysis?
- Are there specific business questions that currently take too much time to answer?
Data quality, clear metrics, access control and a well-structured analytical model are just as important as the AI technology itself.
Where Should Businesses Start?
ERP Analytics MCP is currently a public preview capability. Microsoft notes that preview features are not intended for production use and may have restricted functionality.
For now, the preview stage is best used to explore practical use cases and assess readiness, rather than treating MCP as a replacement for existing reporting systems.
A good starting question is:
“Which business questions currently take too much time to answer?”
Look for areas where teams repeatedly prepare reports, combine information manually, or spend more time finding data than acting on it.
A focused use case can help an organisation evaluate whether conversational analytics actually delivers measurable value.
The Future of ERP Analytics Is Becoming More Conversational
ERP analytics has traditionally required users to work through reports, dashboards, filters and analytical tools.
MCP introduces another possibility: AI agents can interact with the analytical layer itself.
By connecting AI agents with the Business performance analytics data model, MCP could make ERP analytics more conversational and accessible.
This does not mean dashboards disappear or that data professionals become unnecessary.
Instead, the way people interact with enterprise information could gradually change.
The future may be less about creating a new dashboard for every question and more about helping users ask better questions of data they already trust.
Final Thoughts
MCP does not replace ERP systems, Business performance analytics, or data professionals. It adds another way for AI agents to work with enterprise data and analytical tools.
For businesses, this could represent an important step toward making ERP intelligence easier to explore, understand, and use in everyday decision-making.
It creates a more connected path from business data to analysis, from analysis to insight and from insight to action.
At Nimus Technologies Pvt. Ltd., we help businesses modernise Microsoft-based solutions that connect ERP, data, analytics, automation and AI with real business processes.
Having business data is only the beginning. The real advantage comes from understanding it and acting on it.
Frequently Asked Questions
What is Dynamics 365 ERP Analytics MCP?
Dynamics 365 ERP Analytics MCP is Microsoft’s Model Context Protocol capability that enables AI agents to access and analyse Business performance analytics data through natural-language questions.
Do users need to know DAX?
No. Users can ask questions in natural language while the AI agent generates the required DAX queries for the analysis.
What type of ERP data can be analysed?
The capability works with data available in the organisation’s Business performance analytics environment. Microsoft identifies areas including Record-to-Report, Procure-to-Pay and Order-to-Cash, depending on the organisation’s configuration.
Is ERP Analytics MCP generally available?
No. It is currently a public preview capability. Microsoft states that preview features are not intended for production use and may have restricted functionality.
Does MCP replace traditional ERP reports?
No. Traditional reports and dashboards remain valuable for standardised reporting and monitoring. MCP provides an additional conversational way to explore analytics and investigate business questions.
Is ERP Analytics MCP secure?
Microsoft states that ERP Analytics MCP enforces row-level security based on authenticated user roles, helping users access only the Business performance analytics data they are authorised to see.