Agentic AI Compare

Microsoft and Lima Juno, question by question.

Microsoft and Lima Juno — Agentic AI both bring agents to supply chain work, and each of them starts from a different place.

MicrosoftLima JunoLand data orshortcut it inBuild the PowerBI modelAsk Copilot inplain wordsSee the query itbuiltAct throughPower AutomateRegister datawhere it livesMap to thesupply chainontologyAsk in plainlanguageAct at the levelyou setLearn and auditevery decisionthe upper lane follows Microsoft’s own public material · checked 19 September 2026
How each one works, left to right. The upper lane follows Microsoft’s own public material; the lower lane is Juno. Checked 19 September 2026.
9
questions asked of both products on this page
method
13
dated public sources behind the Microsoft column
catalogue
19 Sep 2026
the day every source on this page was checked
method
A0–A4
the autonomy levels you set for each Juno agent
product
In their own terms

What Microsoft describes today

Drawn from the numbered sources at the foot of this page.

Microsoft brings conversational analytics through Power BI Copilot and Fabric data agents, with Copilot Studio and Microsoft Foundry building wider business and coding agents on top. Fabric IQ adds a business ontology, still in preview through mid-2026. Gartner names Microsoft a Leader across its 2026 quadrants for analytics, conversational AI and AI application development platforms [12][13].

ProductFabric, Power BI Copilot and Copilot Studio
GroupConversational analytics on your warehouse
Public sources used13, each checked on 19 September 2026
The nine questions

The same nine questions, answered twice

Numbers in brackets point to the numbered sources at the foot of the page. The line under each question says what a complete answer contains.

1 · Where must the data live for questions and agents to work?

A complete answer names the systems the data has to be copied into, and the systems that are read where they stand.

MicrosoftFabric brings data together in OneLake: shortcuts read Amazon S3, Google Cloud Storage and Dataverse in place, while mirroring copies Oracle, SAP Datasphere, Snowflake and SQL Server data into OneLake for Copilot and Fabric agents to use. Ontology bindings work only on managed lakehouse tables held there [1][2].
Lima JunoYour rows stay in the systems that hold them. Juno registers tables through the Lima data fabric and reads them in place, so a warehouse sits beside SAP, Oracle and planning data in one answer.

2 · How far does it reach into SAP, Oracle and planning systems?

A complete answer names the interface used for each system and says which of them are live today.

MicrosoftMirroring lands a copy of Oracle and SAP Datasphere data inside OneLake for Fabric agents to query; separately, a premium Copilot Studio connector calls SAP's own interface functions directly, reads tables, and supports commit and rollback through an on-premises gateway with each user's own sign-in [2][3].
Lima JunoMore than 40 connectors cover SAP ECC and S/4HANA, Oracle Fusion and E-Business Suite, planning suites, warehouse systems, lakes, databases, files and REST services. One question can join several of them, and the one agent in production, the PO cancellation agent, runs on federated ERP data the same way.

3 · How is the shared meaning, the semantic model or ontology, built, and by whom?

A complete answer says what arrives ready, what your team builds, and how long that modelling work takes.

MicrosoftA Power BI semantic model comes first, and Microsoft's guidance warns that Copilot may misread data left unprepared. Fabric IQ can generate a draft ontology automatically from that semantic model, though keys, time bindings and relationships still need a person's hand, and the ontology stayed in preview through mid-2026 [4][5].
Lima JunoLima’s supply chain ontology arrives filled in: materials, plants, suppliers, orders and stock. Juno proposes a mapping for each registered column with a confidence and a reason; your team confirms, adjusts and extends it.

4 · How do business users ask questions, and is the working shown?

A complete answer shows the question, the query that ran, the sources read and the access rules applied.

MicrosoftPeople ask questions inside Power BI or a Fabric data agent, which routes each one to the matching query language across up to five sources. Builders can inspect the generated query while tuning it, though everyday answers cap at 25 rows by 25 columns and stay in English at this stage [4][6].
Lima JunoPeople ask ChatLima in plain language, in its own screen, in Microsoft Teams or through the Power BI connector. Each answer travels with its working: the ontology terms, the systems read, the seconds taken and the query.

5 · How are agents and rules defined, and by whom?

A complete answer says who writes a rule, in which language, and how it is reviewed before it runs.

MicrosoftCopilot Studio lets people describe an agent in plain language on a low-code canvas, with templates and an Agent Store for common patterns; Microsoft Foundry serves coding teams building hosted, multi-agent workflows with more control over each step [7][8].
Lima JunoA planner writes the policy in plain language, and the Planner Agent turns it into a reviewable planning table of tasks, data and rules. The PO cancellation agent, built this way, runs in production; Lima’s agent blueprint designs 960 further roles across five chains, the other supply chain task agents among them, yet to be built.

6 · How is autonomy set, and how do approvals work?

A complete answer gives the levels available, who approves what at each one, and how a level is raised and lowered.

MicrosoftCopilot Studio applies data policies across knowledge sources, connectors and triggers, together with credit caps and environment routing; a graded, numbered autonomy setting is undocumented on the pages reviewed, and approval steps for a given agent action stay for the customer to configure [8][9].
Lima JunoEach agent carries a level you set, A0 to A4. At A2 a named person approves every action; at A3 the agent acts inside value, budget and confidence limits and sends exceptions to people. The level is one of eight settings on an agent, each set by a named person.

7 · How do actions reach the ERP, and is each write confirmed?

A complete answer names the interface for each ERP and says where the acknowledgement of a write is kept.

MicrosoftThe SAP ERP connector calls BAPI and RFC functions and supports commit and rollback through an on-premises gateway, so an approved change reaches SAP directly; the Fabric data agent stays read-only, and operations agents trigger Power Automate or Activator flows for any downstream action [3][10].
Lima JunoWrite-back uses each ERP’s own supported interfaces: released APIs and BAPIs for SAP, REST resources and interface tables for Oracle. It starts per application after a confirmed test write, and every write keeps the acknowledgement. The PO cancellation agent in production writes back this way, under human approval.

8 · How does it learn from people’s decisions, and what is audited?

A complete answer says what is recorded for each decision and how that record shapes the next recommendation.

MicrosoftMicrosoft Foundry lists a procedural-memory feature in private preview, aimed at learning across runs; Purview and Sentinel record audit logs, and Agent 365 adds a registry with analytics and lifecycle management for every deployed agent, generally available from May 2026 [10][11].
Lima JunoEvery accept, edit and override is stored with the rule version, the facts at that moment and the outcome, so the next recommendation improves. The audit trail holds signal, reasoning, limits, approval, action and acknowledgement for each run; in production, 100% of the cancellation agent’s actions trace to a rule.

9 · What is the pricing unit, is there a trial, and where do analysts place it?

A complete answer names the unit of charge, the route to try it, and the analyst reports that cover the category.

MicrosoftPower BI Pro costs $14 and Premium Per User $24 per user monthly, though Copilot itself needs a paid Fabric capacity metered in compute seconds; Copilot Studio sells credit packs at $200 for 25,000 credits, with a free Azure trial credit. Gartner names Microsoft a Leader in its 2026 Analytics and Business Intelligence and Conversational AI Platform quadrants [6][12][13].
Lima JunoJuno is licensed with the Lima platform and priced per engagement. The token manager budgets and meters every model call, per agent and per team. Twenty use cases are worked through on this site, one page each, and the analyst guide sets out the markets these products sit in.
Fit

When to choose Microsoft

Situations in which Microsoft’s own product is the better first move.

You already run their productOrganisations already standardised on Power BI and Fabric, ready to prepare a governed semantic model as the base for Copilot answers.
Your own team builds the agentsTeams building custom, coded agents on Microsoft Foundry alongside a low-code canvas for business-authored agents in Copilot Studio.
Analyst placement weighs heavilyBuyers who value Microsoft's Leader placement across the 2026 Gartner quadrants for analytics, conversational AI and AI application development platforms.
The write into the system is checkedSAP customers who want a licensed, direct path from Copilot Studio into BAPI and RFC calls with commit and rollback.
Beside them

What Juno adds

Many clients keep Microsoft and add Juno beside it; these are the things it brings.

Each card links to the capability page that shows the mechanism.

Questions
Can we run both products?

Yes, and many estates do. Juno registers Microsoft’s data beside the ERP and the planning system, answers questions across all of them and runs agents at the level you set for each one.

Where do the Microsoft answers come from?

From Microsoft’s own public pages, press releases and documentation, listed at the foot of this page with their publication dates. Where the public material leaves a point open, the answer says so.

How current is this page?

Every source was checked on 19 September 2026. Each vendor releases new agent features often, so treat a page older than a quarter as a starting point for the briefing.

Sources

Every claim, with its publisher and date

The Microsoft column rests on public material only.

  1. Microsoft, Fabric IQ product page, undated 2026, checked 19 September 2026 · https://www.microsoft.com/en-us/microsoft-fabric/features/iq
  2. Microsoft Learn, OneLake shortcuts, updated 13 July 2026, checked 19 September 2026 · https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts
  3. Microsoft Learn, SAP ERP connector reference, undated, checked 19 September 2026 · https://learn.microsoft.com/en-us/connectors/saperp/
  4. Microsoft Learn, Fabric data agent concept, updated 11 May 2026, checked 19 September 2026 · https://learn.microsoft.com/en-us/fabric/data-science/concept-data-agent
  5. Microsoft Learn, Fabric IQ ontology overview, updated 21 July 2026, checked 19 September 2026 · https://learn.microsoft.com/en-us/fabric/iq/overview
  6. Microsoft, Power BI pricing, undated, checked 19 September 2026 · https://www.microsoft.com/en-us/power-platform/products/power-bi/pricing
  7. Microsoft, Copilot Studio product page, undated, checked 19 September 2026 · https://www.microsoft.com/en-us/microsoft-365-copilot/microsoft-copilot-studio
  8. Microsoft Learn, Copilot Studio security and governance, updated 8 August 2026, checked 19 September 2026 · https://learn.microsoft.com/en-us/microsoft-copilot-studio/security-and-governance
  9. Microsoft Learn, Copilot Studio requirements and messages management, updated 3 August 2026, checked 19 September 2026 · https://learn.microsoft.com/en-us/microsoft-copilot-studio/requirements-messages-management
  10. Microsoft, Foundry Agent Service at Build 2026, 2 June 2026, checked 19 September 2026 · https://devblogs.microsoft.com/foundry/agent-service-build2026/
  11. Microsoft, Agent 365 product page, undated, checked 19 September 2026 · https://www.microsoft.com/en-us/microsoft-agent-365
  12. Microsoft Fabric Community blog, Microsoft named a Leader in the 2026 Gartner Magic Quadrant, 10 July 2026, checked 19 September 2026 · https://community.fabric.microsoft.com/blog/-/Microsoft-named-a-Leader-in-the-2026-Gartner-Magic-Quadrant-for/5262403
  13. CX Today, Gartner Magic Quadrant for Conversational AI Platforms 2026, 15 July 2026, checked 19 September 2026 · https://www.cxtoday.com/customer-analytics-intelligence/gartner-magic-quadrant-conversational-ai-2026/

Each number in the Microsoft answers above points to the matching entry in this list. Every entry was checked on 19 September 2026.

See the same nine answers on your own estate

Bring two systems and one decision your planners make every week. In the first week we register the data, confirm the mapping with your team, answer your questions in ChatLima and run the first agent at the level you choose.