M365.FM a Microsoft MVP Podcast by Mirko Peters

Mirko Peters - Founder of m365.fm, m365.show and m365con.net

M365.FM is a podcast about Microsoft 365, Microsoft Copilot, AI, Modern Work, security, governance, Power Platform, Azure, and the technologies shaping the future of work.Hosted by Microsoft MVP Mirko Peters, M365.FM brings together Microsoft MVPs, Microsoft employees, product experts, architects, developers, and community leaders from around the world.Each episode goes beyond announcements and hype to explore what Microsoft technologies mean in practice. From Microsoft 365 Copilot and AI agents to Teams, SharePoint, Power Platform, Microsoft Fabric, Entra, Purview, security, governance, adoption, and automation, M365.FM focuses on real-world experience, implementation, strategy, and lessons learned.Expect expert interviews, technical deep dives, practical explainers, and conversations with people building, implementing, and shaping the Microsoft ecosystem.If you work with Microsoft 365, Copilot, AI, Modern Work, or the Microsoft Cloud, M365.FM helps you understand what matters, what works, and what is coming next.Hosted by Mirko Peters, Microsoft MVP. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-a-microsoft-mvp-podcast-by-mirko-peters--6704921/support.

  1. 5 days ago

    What Happens When Sales Promises an Urgent Order

    An urgent customer request sounds simple: sales promises a fast delivery date, marks the order as priority, and asks production to fit it in. But the new order does not enter an empty factory. It enters a schedule already filled with machine reservations, material allocations, setup plans, qualified people, inspection capacity, maintenance windows, and promises made to other customers. The real question is therefore not simply whether the urgent order can be produced, but which existing commitment absorbs the disruption when it moves forward. A PROMISE IS NOT A PRODUCTION PLAN A commercial promise tells the customer what the business intends to deliver. A feasible production date proves that there is actually a path through material, machining, assembly, inspection, packing, and shipping within the available time. ERP can hold requested dates, promised dates, production orders, materials, and routing information, but a priority flag does not create capacity. A CNC machine still has limited hours, inspection still needs qualified people and equipment, and shipping still has carrier cutoffs. Urgency changes priority; it does not remove physical constraints. FINITE CAPACITY EXPOSES THE REAL TRADE-OFF Infinite-capacity planning can place several orders against the same resource and leave the collision for production to solve later. Finite-capacity scheduling forces that conflict into the open. If the urgent order receives Tuesday morning on a CNC machine, another operation loses Tuesday morning. That displaced order may then miss assembly, inspection, or packing windows and lose far more time than the urgent order actually consumed. The first scheduling move therefore creates a chain reaction through the remaining route. MATERIAL DOESN'T OBEY PRIORITY FLAGS Inventory showing as available does not always mean it is usable for the urgent order. Material may already be allocated to another customer order, still be waiting for quality release, require a specific batch or supplier, or have traceability and shelf-life restrictions. Reallocating material can save the urgent customer while quietly creating a shortage somewhere else. The factory has not removed the constraint; it has transferred it. The same applies to fixtures, gauges, special packaging, test equipment, and other physical resources that multiple orders may depend on. MACHINE CAPACITY IS NOT USABLE CAPACITY A machine can have an open calendar slot and still be unavailable for the work. The required setter may not be on shift, an operator may lack the necessary certification, the fixture may be installed somewhere else, or the CNC program may not be released for the current product revision. Real capacity exists only when the machine, people, tools, material, process approvals, and time window come together. That is why an alternate machine is not automatically an alternate production route. A proven alternate route needs approved tooling, programs, quality checks, realistic cycle times, and people who can actually run the work. THE BOTTLENECK MOVES An urgent order may initially look like a machining problem. Once machining finds a solution, the pressure can move immediately to assembly, inspection, testing, packing, or even one person responsible for an approval. A bottleneck is not permanently attached to one machine. It is whichever constraint currently limits the flow of work toward shipment. This is why high equipment utilization does not automatically mean good delivery performance. A plant can have efficient machines and still ship late because the wrong work is waiting at the wrong constraint at the wrong time. THE SECOND-ORDER EFFECTS ARE WHERE THE DAMAGE SPREADS The visible effect of an urgent order is easy to see: it moves forward. The less visible effect is everything that moves backward. One displaced machining operation can delay an assembly component. That missing component can create partial work, additional handling, another inspection window, and finally a missed shipment. Another order may lose a fixture, material allocation, test bench, or skilled person even though it never shares the original machine with the urgent order. Factories operate through dependencies, not isolated departments. An urgent order changes product, process, and resource relationships throughout that network. DELIVERY DATES HAVE TO BE RECALCULATED When work moves, the old customer dates should not simply remain untouched in ERP. A displaced order needs a new feasible path through every remaining operation. Machining must finish before assembly can start, assembly must finish before inspection, and inspection must finish early enough for packing and the carrier cutoff. An order can technically finish production on its due date and still arrive late because the truck already left. Customer service therefore needs a realistic ship date and the assumptions behind it, not reassurance based on a date that the current production situation no longer supports. WHY EXCEL BECOMES THE EMERGENCY CONTROL ROOM In many factories, the planner pulls information from ERP, MES, production supervisors, purchasing, quality, maintenance, and supplier updates into one spreadsheet because that is the fastest way to rebuild the complete situation. Excel itself is not the problem. It is flexible and practical. The problem appears when the spreadsheet becomes the only place where the real production decision exists. Sales sees one date in ERP, planning sees another date in a workbook, and the shop floor follows a sequence changed during the previous shift. The deeper issue is missing shared context between the systems. CONTEXT CONNECTS THE FACTS A machine record, work order, material quantity, operator roster, and customer due date are useful facts. They become useful for urgent-order decisions when the relationships between them are explicit. The system needs to understand that: • This operation belongs to this work order • This work order supports this customer commitment • This operation can run on these approved resources • This material is allocated to this production order • This tool or fixture is required for this process • This person is qualified for this operation • This inspection must happen before shipment A knowledge graph or similar relationship model can help make those dependencies visible and traceable instead of leaving them inside spreadsheets and people's heads. WHERE MICROSOFT FABRIC AND POWER BI FIT Microsoft Fabric can provide a shared data foundation across ERP, MES, maintenance, quality, machine data, and planning information. It can help prepare, govern, history, and connect data used for cross-system analysis. Power BI can expose current load, orders at risk, material status, queue development, and delivery exposure so sales, planning, production, and customer service work from a more consistent view. But neither Fabric nor Power BI is automatically a finite-capacity scheduling engine. A scheduling or optimization layer still needs to test resource calendars, routing dependencies, setups, material availability, skills, maintenance windows, and other constraints before a production option can be considered feasible. SIMULATION BEFORE YOU MOVE THE WORK Instead of immediately pushing an urgent order to the front, simulation allows planning to test the consequences first. Possible scenarios might include: • Move the urgent order ahead of existing work • Add controlled overtime • Use an approved alternate route • Split the shipment • Offer a later delivery date • Decline the requested date when no safe feasible option exists Each option moves risk somewhere. Simulation makes those consequences visible before production starts changing machines, people, materials, and schedules. PREDICTION, SIMULATION, OPTIMIZATION, AND AI These technologies solve different problems. Prediction estimates what may happen. Simulation tests what happens if the plant chooses a specific response. Optimization searches across available options for the best schedule according to defined objectives and constraints. Generative AI can help planners understand those results, ask questions in natural language, summarize the trade-offs, and prepare communication for sales or customer service. AI should not invent finite-capacity schedule mathematics from a prompt. A fluent answer is not proof that the production plan is feasible. WHO GETS TO CALL AN ORDER URGENT? Urgency needs governance. A customer line-down situation is different from a late internal request. A contractual recovery is different from a strategic opportunity. A safety-related requirement may justify disruption that a normal expedite request does not. Without clear categories and decision rights, everything eventually becomes urgent and normal work becomes whatever nobody defended loudly enough. Production should be able to return a feasibility answer that explains what is possible, what conditions apply, and which existing commitments change if the request is accepted. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-a-microsoft-mvp-podcast-by-mirko-peters--6704921/support.

    What Happens When Sales Promises an Urgent Order
  2. 6 days ago

    Why AI Can't Optimize a Factory It Doesn't Understand

    A machine stops in the middle of production. ERP knows the customer orders and due dates, MES knows which operation stopped, maintenance knows the repair status, and the machine layer knows the fault code and exact timestamp. Then someone asks the obvious question: what should we do now? AI can summarize the alarm, find patterns in historical downtime, and explain what probably happened. But unless it also understands which product was running, which orders depend on that operation, which machines are approved alternatives, which tools are available, which operators are qualified, and which quality or process rules apply, it cannot safely optimize the response. That is not primarily an AI problem. It is a factory-context problem. DATA IS NOT THE SAME AS CONTEXT Factories already produce huge amounts of data. ERP, MES, maintenance, quality, historians, PLCs, IoT platforms, and spreadsheets all hold useful facts. The problem is that those facts often remain disconnected.A machine stop code by itself does not tell you whether the event happened during production, changeover, maintenance, or a batch with a strict processing window. A machine can appear idle while still being unusable because the required fixture is unavailable or the qualified operator is not on shift. Context connects the event to the operating situation around it. That includes: • Asset and resource identity • Active operation and work order • Product and revision • Route and alternate routes • Material and batch status • Tooling and fixtures • Skills and shift coverage • Quality restrictions • Maintenance status • Capacity and downstream dependencies • Customer commitments WHY DASHBOARDS ARE NOT ENOUGH Power BI and operational dashboards are excellent for showing what changed. They can expose downtime, growing queues, late orders, scrap, or available capacity. But showing a problem is different from deciding what production should do next. A dashboard may show that another machine is available. It does not automatically know whether that machine is approved for the current product revision, whether the fixture is already reserved, whether quality must approve the transfer, or whether moving the job creates a new bottleneck downstream. Once reports start containing dozens of special-case calculations and planners still export the result to Excel to test alternatives, the missing piece is usually not another visualization. It is an explicit model of the factory rules behind the decision. PREDICTION IS NOT OPTIMIZATIONPrediction can tell you that a machine is likely to fail or that an order has a high probability of being late. That is useful, but it does not tell you what to do. Optimization has a different job. It evaluates possible actions against the rules and constraints of the factory. For example, after a machine failure, an optimizer might test whether affected work can remain on the original resource, move to an approved alternate machine, change sequence, or use overtime. A feasible plan has to respect real conditions. Safety limits, process approvals, material compatibility, operator certification, tooling, quality restrictions, maintenance windows, and sequence rules cannot simply disappear because another machine looks free. AI, OPTIMIZATION, AND RULES HAVE DIFFERENT JOBS Generative AI can help planners understand the situation, search connected information, compare alternatives, explain trade-offs, and create a useful handover. Predictive models can estimate risk. Optimization engines can search for feasible schedules. Deterministic rules can verify that a proposed action respects known production conditions. These components can work together, but they should not be confused with each other. A language model can produce a convincing explanation. That does not prove a production plan is executable. PRODUCT, PROCESS, RESOURCE A useful factory model starts with Product, Process, and Resource. Product describes what is being produced, including revision, material, batch rules, and customer-specific requirements. Process describes the operations, sequence, setup conditions, inspections, alternate paths, and rules required to manufacture it. Resource describes what can perform that work. A resource can be a machine, tool, fixture, furnace, test station, transport device, or person. The important part is the relationship between them. The question is not: “Which machine is free?” The useful question is: “Which available resource can perform the next required operation for this exact product and order under the approved process, tooling, material, quality, staffing, and timing conditions?” KNOWLEDGE GRAPHS WITHOUT THE HYPE A knowledge graph provides one way to represent those connected factory relationships. Instead of storing machines, operations, orders, tools, and materials as isolated records, the graph also represents the relationships between them. A machine can perform an operation. The operation belongs to a route. The route belongs to a product revision. A work order requires that route. A fixture may be required for the operation. The fixture may currently be committed to another job. This makes questions such as “why can’t this order move to Machine 7?” much easier to explain. The answer should not simply be “not feasible.” It should explain that Machine 7 supports the operation but the required fixture is unavailable, the product revision lacks approval, or a downstream quality condition blocks the route. A DIGITAL TWIN NEEDS A JOB A live dashboard is not automatically a digital twin. A useful twin represents a defined part of the physical operation and connects structure, state, rules, and source data around a specific purpose. An asset twin might support maintenance decisions. A line twin might help understand flow and bottlenecks. A production-system twin might connect equipment state to orders, routes, materials, people, quality rules, and delivery commitments. The important question is not “do we have a digital twin?” It is “which user, decision, and time window does this twin support?” ASSET IDENTITY IS FOUNDATIONAL One physical machine can have several identities. Maintenance may use an asset number. MES uses a production resource. ERP uses a work center. The IoT layer sees a controller or tag path. Those identifiers do not need to disappear, but their relationships must be governed. If an AI system guesses that two similar machine names represent the same physical asset, every later decision can be wrong even though the underlying data is technically clean. Asset mappings therefore need ownership, effective dates, source references, and change management. CONSTRAINTS ARE PART OF THE DATA A route may be technically possible and still be unacceptable for production. Hard constraints can include: • Safety limits • Approved recipes • Material compatibility • Machine capability • Operator certification • Quality release • Tool availability • Maintenance restrictions Other constraints represent trade-offs rather than absolute limits. An additional changeover may be acceptable to protect an urgent delivery. Overtime may be allowed for one customer commitment but not another. The system should expose those trade-offs rather than hide them inside an opaque recommendation. CLEAN DATA IS NECESSARY — BUT NOT ENOUGH Accurate timestamps, complete events, standardized identifiers, and reliable interfaces are essential. But a perfectly clean table still does not explain what “available,” “complete,” or “capacity” means. A machine may be mechanically available but unavailable for the current operation. Production may call an order complete when machining finishes while quality still considers the batch unreleased. The semantic model defines those meanings and connects them to the systems that own each fact. That is what gives AI enough context to reason without filling gaps with assumptions. PLANNED STATE AND ACTUAL STATE Factories change continuously. The schedule describes what should happen. The shop floor reports what is actually happening. A useful decision model needs both. Planned state includes expected routes, assigned resources, production times, maintenance windows, material arrivals, and due dates. Actual state includes current machine condition, quantities produced, scrap, queues, real material availability, quality holds, and actual execution progress. Replanning comes from comparing those views while preserving the time and version of the rules that applied when the decision was made. THE THREE-LAYER ARCHITECTURE A practical architecture can be thought of in three layers. The operational layer includes ERP, MES, maintenance, quality, PLCs, historians, and OT systems. These remain the systems that run the factory and own their respective facts. The data and context layer connects those facts. It handles ingestion, identity, history, semantic definitions, relationships, source ownership, and traceability. The decision layer includes dashboards, simulation, optimization, workflows, and AI assistants that help people understand options and make decisions. Those layers should work together without turning AI or the cloud into the direct control layer for production equipment. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-a-microsoft-mvp-podcast-by-mirko-peters--6704921/support.

    Why AI Can't Optimize a Factory It Doesn't Understand
  3. 9 Oct

    Production Schedule Optimization - How to Build Better Production Schedules

    A production schedule can look correct while the factory has already moved on. A machine runs slower than expected, a setup takes longer, material is still waiting for release, or an urgent order enters the plan. ERP still shows the original dates, MES shows current execution, and the supervisor has already started adjusting the sequence on the floor. The real challenge is keeping the schedule connected to what production can actually do now. FROM PRODUCTION PLAN TO EXECUTABLE SCHEDULE A production plan describes what the business intends to make. A production schedule turns that demand into real work on specific machines, during specific shifts, with the required materials, tools, people, and approvals available. That means a schedule needs more than due dates and work-order numbers. It needs routes, operation times, setup rules, resource capability, material status, quality gates, calendars, tooling, and enough execution information to understand whether the next operation can really start. ERP, MES, AND SHOP-FLOOR REALITY ERP should remain the source for customer demand, production orders, due dates, inventory, purchasing, and commercial commitments. MES works closer to execution and tells the scheduling process which operations are running, what quantities are complete, where work is blocked, and what actually happened during the shift. Neither system provides the complete scheduling picture alone. A credible schedule combines business priorities from ERP with current execution information from MES and relevant shop-floor events from OT systems. FINITE-CAPACITY AND CONSTRAINT-BASED SCHEDULING Constraint-based scheduling begins with what the factory can actually support. Instead of loading orders against preferred dates and discovering overload later, the scheduler checks whether the work fits the real capacity available. Typical constraints include: • Machine availability and capability • Setup and changeover time • Material and batch availability • Operator skills and shift calendars • Fixtures, tools, gauges, and secondary resources • Maintenance periods • Quality holds and inspection requirements • Operation sequence and routing rules A machine may have eight available hours. The schedule should not quietly assign twelve hours of work and leave production to solve the difference. HARD CONSTRAINTS VS SOFT CONSTRAINTS Some rules cannot be broken. A machine without the required capability cannot run the operation, material on quality hold cannot be consumed, and an operation cannot begin before a required predecessor is complete. Other rules are preferences. Production may prefer fewer changeovers, similar products grouped together, or a stable sequence through the current shift. Those preferences matter, but they may be overridden when an urgent customer order or major disruption requires it. The scheduler therefore needs to distinguish between what is impossible and what is simply undesirable. CAPACITY IS MORE THAN AN EMPTY MACHINE An idle machine is not automatically usable capacity. The required fixture may be somewhere else, the machine may lack approval for the product revision, the gauge may be out of calibration, or the qualified operator may not be on shift. This is why detailed scheduling needs capability data rather than only resource groups and calendar hours. The important question is not whether the machine is free. It is whether the complete operation can be executed under the conditions that apply to that specific order. REAL-TIME RESCHEDULING WITHOUT CONSTANT CHAOS Real-time data does not mean the entire schedule should change every time a machine sends an alarm. Production needs stability long enough for people to prepare materials, install tools, perform setups, and execute the work. Rescheduling should therefore be exception-based. A confirmed breakdown, serious material shortage, quality hold, major execution delay, or approved priority change may justify a scheduling review. Minor deviations can simply remain in the execution history. Freeze zones can protect near-term work that has already been staged or started, while work farther into the future remains more flexible. OBJECTIVES AND TRADE-OFFS A feasible schedule is not automatically the best schedule. The factory may want to protect delivery dates, reduce setups, maximize bottleneck utilization, control work in process, or keep the schedule stable. Those objectives can conflict. Moving an urgent order forward may protect one customer commitment but create another setup, delay another order, and disturb work already prepared on the floor. Optimization can calculate alternatives quickly, but planners still need to decide which trade-offs the business is willing to accept. WHERE MICROSOFT FITSAzure can provide the integration layer connecting ERP, MES, OT systems, and a scheduling or optimization service. Microsoft Fabric can bring historical scheduling, execution, quality, maintenance, and selected machine data together for analysis and governance. Power BI can help teams review schedule adherence, bottlenecks, repeated delays, planned versus actual operation times, and the reasons schedules change. Power Platform can support controlled workflows around urgent orders, route changes, quality decisions, and other exceptions that require human approval. Microsoft technologies support the scheduling architecture, but a specialized APS or optimization engine is still needed when the factory requires finite-capacity scheduling, constraint solving, sequencing, and optimization. KEY TAKEAWAYS • ERP provides the business plan while MES provides execution reality. • Detailed scheduling needs finite capacity, not generic available hours. • Resource capability matters more than simple machine availability. • Tools, skills, quality, materials, and maintenance can all become scheduling constraints. • Not every shop-floor event should trigger a new schedule. • Freeze zones help protect work already prepared or underway. • Optimization should expose trade-offs rather than silently move work. • Fabric, Azure, Power BI, and Power Platform can support the surrounding data, integration, analytics, and workflow architecture. • Human judgment remains part of the scheduling process.  better production schedule is not one that never changes. It is one that reflects the real constraints of the factory, changes only when necessary, and gives planners and production teams a clear view of what can actually happen next. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-a-microsoft-mvp-podcast-by-mirko-peters--6704921/support.

    Production Schedule Optimization - How to Build Better Production Schedules
  4. 8 Oct

    What Is an Industrial Data Model

    A factory can collect enormous amounts of data and still struggle to answer a basic operational question: what does this event actually affect? ERP knows customer orders, materials, planned dates, and inventory. MES knows what is executing on the shop floor. PLCs and SCADA know machine states, alarms, and process values. Maintenance knows asset condition and service history. Quality knows inspection and release status. Engineering knows the product definition. The problem is not usually a lack of data. The problem is that these systems describe the same factory through different names, IDs, states, and rules. An industrial data model creates shared meaning across those boundaries. It defines the factory objects that matter, gives them stable identity, and describes how products, processes, resources, orders, materials, people, tools, quality records, and machine events relate to each other. The goal is not to replace ERP, MES, maintenance, or other source systems. The goal is to make their information understandable as one connected production context.     PLENTY OF SYSTEMS — NO SHARED MEANING A modern plant already has specialized systems for almost every important job. ERP manages demand and commitments. MES manages execution. PLCs control equipment. SCADA presents machine conditions. Historians store process data. Maintenance systems manage assets and service work. Quality systems maintain inspection records, and Power BI can combine information for reporting. Each system exists for a reason. The problem begins when the same real-world object appears differently in every one of them. A machine may be represented as a work center in ERP, an asset number in maintenance, a resource in MES, a group of OPC UA nodes in the control system, and a completely different friendly name on the shop floor. An industrial model does not force all of those systems to use one identifier. Instead, it records how those references relate to the same physical or logical object. That gives the factory a stable identity layer without destroying the local structures each source system needs. WHAT AN INDUSTRIAL DATA MODEL ACTUALLY IS An industrial data model is a shared set of rules describing what matters in the factory and how those things connect. It answers practical questions such as what counts as a production order, what a product revision represents, how a work center differs from a physical asset, when material is released, and what it actually means for a machine to be available. The model can describe: • Object types and identities • Properties and states • Relationships between factory objects • Source-system references • Effective dates and versions • Conditions attached to relationships • Ownership of definitions and rules This lets several systems describe different aspects of the same production situation without collapsing them into one misleading status. An order can be released in ERP while its current MES operation remains blocked. A machine can be mechanically healthy while still unavailable because the required fixture is missing. Those facts can all be true at the same time. THE MODEL IS NOT THE DATA PLATFORM Microsoft Fabric, SQL databases, historians, data lakes, and other platforms are useful for storing, moving, governing, and analyzing information. But none of them can determine what a work center means in your factory simply because the records are stored together. You can load ERP orders, MES execution records, maintenance events, quality results, and machine telemetry into one Lakehouse and still be unable to answer whether a particular order can move to another machine before the end of the shift. That answer depends on relationships. Which product revision is involved? Which operation must run next? Which resources are approved for that operation? Which tooling is required? Is the operator qualified? Does the current machine state allow the work? Is an inspection rule attached to the alternate route? The platform can host and query those relationships, but the factory still has to define them.    WHY TABLES ALONE OFTEN BECOME DIFFICULT Relational tables are not the problem. ERP, MES, maintenance, and many manufacturing applications depend on relational models because they are excellent for transactions and structured records. The difficulty appears when production questions cross many relationships that change over time. A product revision may require several operations. An operation may be approved on multiple resources. One machine may support only certain product versions, tooling combinations, size ranges, or inspection requirements. Operator qualifications may expire. Engineering changes may invalidate a previously approved route. All of this can be represented in tables, but the logic often becomes scattered across reports, SQL queries, spreadsheets, and local exception lists. Different reports then rebuild the same factory relationships differently. The industrial model provides a shared relationship layer so the rules can be defined once, governed, and reused instead of rediscovered every time someone asks a difficult production question.  PPR — PRODUCT, PROCESS, RESOURCE A practical starting structure is PPR: Product, Process, Resource. Product answers: what are we building? Process answers: how does the work need to happen? Resource answers: what can perform that work under real production conditions? PPR provides a simple backbone for connecting isolated records into a production model. It avoids trying to model the entire enterprise immediately and instead focuses on the relationships that determine whether work can actually happen. PRODUCT IS MORE THAN A PART NUMBER A product definition may include the product family, specific variant, revision, bill of material, customer configuration, material requirements, inspection requirements, and quality rules. This matters because two records with the same broad part number may not be interchangeable. A new revision may require a tighter tolerance, different process parameters, another inspection step, or equipment with higher capability. Engineering systems such as PLM may own design intent. ERP may hold the material master and planning version. MES may hold a production definition. Quality may maintain an inspection plan. The industrial model connects those references so production can answer a much more important question than “what part number is this?” It can answer: are we building the correct revision under the rules that currently apply? PROCESS DEFINES HOW WORK SHOULD HAPPEN The process side describes the approved route through production. It includes more than a list of machines. It can describe operation sequence, setup requirements, inspection points, wait times, rework paths, approvals, handoffs, and conditions that must be satisfied before work continues. A planned process definition describes how work is supposed to happen. MES execution data records what actually happened for a specific order. Both matter. Without the planned process, you cannot determine whether execution followed the approved route. Without the execution history, you cannot learn what actually happened during production. RESOURCE MEANS CAPABILITY — NOT JUST A MACHINE A production resource can be a machine, line, workstation, tool, fixture, operator, test rig, transport system, or another capability needed to perform work. This distinction is critical because a machine can be technically available while the operation remains impossible. The required fixture may be in use elsewhere. A tool may be out of calibration. The only qualified operator may not be on the current shift. A machine may support the product family but not the current revision. The model therefore separates design capability from current state. Capability asks what a resource can perform under defined conditions. Current state asks whether that capability can actually be used right now. Production feasibility depends on both. THE RELATIONSHIPS CARRY THE REAL MEANING The value of PPR comes from the relationships between Product, Process, and Resource. A product requires a process. A process contains operations. An operation can be performed by certain resources, but often only under specific conditions. For example, a relationship may effectively state that a particular machine can perform Operation 20 for a defined product family and revision range when Fixture F12 is installed, the machine is within its approved operating condition, and a qualified operator is assigned. That sounds detailed because production is detailed. Those are the checks people already make manually when they move work after a machine breakdown. The industrial model simply makes the logic explicit and reusable. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-a-microsoft-mvp-podcast-by-mirko-peters--6704921/support.

    What Is an Industrial Data Model
  5. 7 Oct

    How Machine Data Reaches Microsoft Fabric - From OPC UA to Real-Time Analytics

    Getting machine alarms, sensor values, production counters, and fault events into the cloud is easier than ever. OPC UA exposes the machine signal, an edge layer collects it, MQTT can distribute it locally, and Microsoft Fabric can ingest and analyze the resulting stream. The difficult part starts after the data arrives: how do you turn raw telemetry into enough production context to support an actual decision? This episode follows one machine signal from the factory floor through the Microsoft industrial data stack. It starts with OPC UA, moves through the edge and MQTT, crosses securely into Azure and Microsoft Fabric, and then looks at how Eventstream, Eventhouse, KQL, Lakehouse, Power BI, MES, ERP, maintenance data, and production context fit together. The goal is not simply to show another telemetry pipeline. It is to explain what has to happen before machine data becomes useful for production, maintenance, quality, and planning. FROM MACHINE STOPPAGE TO PRODUCTION CONSEQUENCE A machine stoppage looks simple at the controller level. The state changes from running to faulted, a fault code appears, the part counter stops, and perhaps other values change around the same time. That information is useful, but production usually asks a different question: which work order is affected, how much quantity remains, can another machine take over, and does this delay threaten a delivery? The machine understands its own condition, but it does not automatically understand the business consequence. MES may know the operation and work order. ERP may know the due date and demand. Maintenance may understand the equipment history. Quality may determine whether output can still be used. That is why a fast telemetry pipeline is only the beginning of the architecture. OPC UA — WHERE THE SIGNAL ENTERS THE DATA PATH OPC UA provides a standardized industrial interface for accessing information from equipment without requiring every cloud application to understand proprietary controller protocols. A server can expose variables, machine states, alarms, events, methods, timestamps, quality information, and sometimes structured equipment models. That structure matters because a useful industrial event should carry more than a numeric value. Source timestamps, server timestamps, quality status, units, source identity, and the original OPC UA node information can all become important later when somebody asks where a number came from or why a production calculation looks wrong. The episode also emphasizes that a tag name is not a data model. A field called “temperature” or “machine state” still needs context such as the asset, engineering unit, allowed range, state definition, and the production situation in which the signal was observed.  KEEP THE OT BOUNDARY CONTROLLED Machine connectivity should not turn the production network into an extension of the corporate or cloud environment. Industrial networks need controlled boundaries, typically including segmentation and an industrial DMZ, so that approved edge systems can communicate with equipment without giving enterprise applications direct access to controllers. The recommended pattern is generally outbound-oriented. The edge layer connects to approved OPC UA endpoints and then sends selected information toward cloud services through controlled destinations, ports, protocols, and identities. Analytics platforms should receive data without inheriting broad rights to browse or modify production systems. Certificates, firewall rules, trust relationships, expiry handling, and ownership also need to be treated as operational processes rather than one-time configuration work. THE EDGE SHOULD IMPROVE DATA — NOT INVENT BUSINESS MEANING The edge layer sits between the machine environment and the wider data platform. Its first responsibility is connection, but it can also filter, normalize, buffer, enrich, and route the information before it leaves the plant. Useful edge responsibilities include: • Selecting only signals required for defined use cases • Filtering unnecessary high-frequency data • Applying agreed unit conversions • Preserving source timestamps and quality indicators • Adding stable site, line, and asset identifiers • Buffering during cloud outages • Handling retry and back-pressure behavior • Exposing connector and queue health • Performing selected local calculations or AI inference where latency or disconnected operation requires it The important boundary is that the edge should add facts it knows with confidence. It should not guess which production order is active based on stale information or quietly create business context that belongs to MES, ERP, planning, or quality systems.  AZURE IOT EDGE VS AZURE IOT OPERATIONS The episode compares two Microsoft approaches for running industrial edge workloads. Azure IoT Edge works well when the requirement is focused around a gateway or individual device. Containerized modules can collect data, apply local logic, buffer information, and send it upstream through Azure IoT Hub. This can be a practical choice for a defined cell or smaller workload where the organization wants a lighter operating footprint. Azure IoT Operations is positioned more as a site-level industrial data environment. It runs on an Azure Arc-enabled Kubernetes environment and includes capabilities around OPC UA connectivity, MQTT, data flows, and asset or device management. That can make more sense when a site has several lines, multiple machine vendors, local consumers, and a need to repeat a governed edge pattern across plants. The decision should not be based on which platform has the longest feature list. It should be based on the operating model the organization is prepared to support. Azure IoT Operations provides broader site-level capabilities, but it also introduces Kubernetes, Arc, cluster operations, monitoring, storage, patching, and recovery responsibilities. MQTT AS THE FACTORY EVENT BACKBONE When several consumers need the same machine events, MQTT can dramatically simplify the architecture. The machine connector publishes once to a broker, and maintenance applications, local historians, cloud data flows, or other approved consumers subscribe independently. That removes many point-to-point dependencies. A new application can subscribe to an approved topic without creating another direct link into the PLC or OPC UA server. Topic design still matters. A hierarchy can represent site, area, line, cell, and asset, but the topic should not become the entire data model. Important facts such as event identity, source timestamp, asset ID, quality, contract version, and event type should remain in the message payload so the event stays understandable even when stored, replayed, or routed elsewhere. THE UNIFIED NAMESPACE IS A CONTRACT — NOT JUST A TOPIC TREE The Unified Namespace pattern can provide a shared operational contract across industrial systems. The useful part is not simply having one huge MQTT hierarchy. The value comes from agreeing how assets are identified, how events are shaped, who owns the data, how schemas change, and which systems are authoritative for different facts. A good Unified Namespace can provide a stable way to identify assets and publish governed operational events while allowing source systems to keep ownership of their own records. That contract should define things such as: • Asset identity • Event types • Message shape • Timestamp rules • Quality information • Ownership • Security • Versioning • Change management MQTT can transport the contract, but MQTT does not create the contract. FROM OPC UA NOTIFICATION TO MQTT EVENT Turning an OPC UA notification into an MQTT event is more than protocol translation. The connector needs to preserve evidence from the industrial source while transforming the message into a format that downstream systems can understand. For a state event, that could include a stable asset ID, signal name, value, source time, source quality, event type, and the original OPC UA node reference. For an alarm, additional fields might include fault code, severity, and source text where appropriate. Different event types should remain distinct. Machine state, fault events, production counts, quality rejects, and condition measurements are not all the same type of telemetry and should not be forced into a vague generic record if consumers need different behavior. THE PACKAGING CELL EXAMPLE The episode uses a packaging cell to show why context matters even when the source signals appear simple. Machine state, good count, reject count, speed, and fault information may look straightforward, but each needs interpretation. A zero speed can mean failure, planned changeover, waiting for material, or another expected condition. A reject counter may not identify which product or inspection point caused the rejection. A machine speed value means very little without the product-specific expected speed. A fault code may help maintenance but still does not explain the impact on the current order. The design therefore needs explicit states, source evidence, timestamps, and links to the production context that will be added later. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-a-microsoft-mvp-podcast-by-mirko-peters--6704921/support.

    How Machine Data Reaches Microsoft Fabric - From OPC UA to Real-Time Analytics
  6. 6 Oct

    Connectivity Is Not Integration — Why Your Connected Factory Still Can't Answer the Right Questions

    A connected factory can move machine signals in milliseconds and still fail to answer the operational questions that actually matter. A packaging machine stops, the PLC reports the fault, OPC UA exposes the event, MQTT distributes it, and the dashboard updates immediately. Maintenance receives an alert and everything appears connected. Then the planner asks which customer shipment is now at risk, and suddenly the answer requires MES data, ERP records, maintenance history, quality status, production quantities, delivery commitments, and often a spreadsheet. That gap is the focus of this episode: connectivity moves signals, while integration connects meaning, constraints, ownership, timing, and consequences.   CONNECTIVITY MOVES SIGNALS — INTEGRATION CONNECTS MEANING OPC UA, MQTT, edge gateways, brokers, and modern industrial connectivity platforms solve important problems. They make machine data accessible, standardize transport, reduce point-to-point connections, and allow events to move between machines, applications, and cloud services. But transporting an alarm does not explain its business consequence. A fault code can arrive perfectly, keep the correct timestamp, and reach every subscriber within seconds. That still does not tell a planner whether the stopped machine affects an urgent order, whether approved inventory already exists, whether the current output is on quality hold, or whether another resource can take over. To answer those questions, the architecture needs relationships between the machine, the active operation, the work order, the product, material status, quality state, maintenance information, and customer demand. ONE ALARM, MULTIPLE SYSTEMS, NO COMPLETE ANSWER The episode follows one packaging-machine alarm through the systems that typically hold different parts of the production story. The PLC knows what happened at the machine. MES understands which operation and work order are active. ERP knows demand, due dates, inventory, and customer commitments. Maintenance knows service history and outstanding work. Quality decides whether the produced output can actually be released. Each system can be correct while the factory as a whole still cannot answer the operational question. This is where people become the integration layer: someone checks MES, someone else opens ERP, maintenance searches the service history, quality verifies release status, and somebody eventually pulls the information together manually. That approach works until decisions need to happen quickly, systems change, or the person who understands all the hidden mappings is unavailable.    UNIFIED NAMESPACE: A BETTER HIGHWAY, NOT THE FACTORY MAP A Unified Namespace can improve this situation significantly by replacing many direct system-to-system connections with a shared publish-and-subscribe environment. Machines and applications publish information once, consumers subscribe to what they need, and new systems can join without another custom connection back to the equipment. That reduces plumbing, but it does not automatically create context. An MQTT topic structure can tell you where information came from, but it cannot determine which production order was active, which material was involved, which quality state applied, or which customer delivery depends on that order. Publishing MES, ERP, quality, and machine events into the same broker does not automatically create the relationships between them. Those relationships still have to be modeled and governed.     THE TAG NAMING TRAP Good naming conventions help people discover data, but names are not identities. One system may call a machine Packer7, maintenance may use PK07, ERP may use a production-resource code, and a cloud platform may know the same equipment through a device identity. All of those records can refer to the same physical asset. Without governed identity, organizations gradually build mapping tables, custom scripts, report-specific translations, and undocumented assumptions. Then the machine gets moved, rebuilt, renamed, or receives a new controller and the data still flows while the relationships quietly become wrong. Friendly names are useful for people, but stable identity is what keeps systems connected over time. ERP AND MES HAVE DIFFERENT JOBS ERP and MES are related but they should not be treated as the same system. ERP works at the business and planning level with demand, supply, inventory, customer commitments, production orders, and financial consequences. MES works closer to execution with operations, production resources, operators, downtime, quantities, material consumption, and the actual progress of work on the floor. The architecture becomes more reliable when those responsibilities remain clear and the systems are deliberately linked instead of forcing one platform to own everything. A machine can report that production is complete while quality still has the output on hold. MES may show an operation as finished while ERP has not yet posted the finished goods receipt. Those states can all be valid because they describe different moments in the same production process.     DATA IS THE SIGNAL — CONTEXT IS THE SURROUNDING FACTORY A temperature value is data. Context explains which sensor produced it, which machine contains that sensor, which product was running, which recipe applied, what unit was used, whether the sensor was calibrated, and what operating range was acceptable for that production run. The same applies to a machine-down event. The signal tells you that something stopped. Context tells you which operation was affected, which order was running, what material was being used, whether the produced output is actually available, whether another resource could take over, and which customer commitment may now be at risk. Useful industrial context usually includes: • Asset context — what the physical thing is and where it sits • Process context — what the resource can actually do • Order context — what work is currently running • Material context — which lots and components are involved • Quality context — whether output is released, restricted, or held • Time context — which relationships were valid when the event happened Once those relationships exist, the same machine event becomes much more useful for planning and decision-making.     SCHEMA, ONTOLOGY, AND GRAPH ARE DIFFERENT THINGS A schema defines the shape of a record. It can require fields such as asset ID, event timestamp, fault code, work-order ID, or engineering unit. An ontology defines the shared meaning of the concepts and relationships used across the factory. A graph provides a practical way to store and query those connected entities. For example, a machine can belong to a production line, a sensor can measure a component, an operation can belong to a work order, a material lot can be consumed during that operation, and finished output can have a quality status. A graph makes those connections easy to traverse, but simply choosing a graph database does not create meaningful relationships. The quality comes from the model, ownership, timing, identity, and governance around those links.  FROM MACHINE ALARM TO A USEFUL PRODUCTION ANSWER If those relationships are modeled, the packaging-machine alarm can be traced through the wider production context. The fault event identifies the physical asset, the asset connects to the production resource, the resource connects to the active operation, the operation connects to the work order, and the work order connects to product, quantity, demand, and delivery commitments. Material relationships show what was consumed. Quality relationships show whether completed production is actually usable. Maintenance relationships provide service history and known issues. Instead of only saying “Packer 7 stopped,” the architecture can begin to explain which order was running, how much quantity remains, whether completed output is available, and which customer delivery may now be affected. That is the difference between event monitoring and actual decision support. SEMANTIC GOVERNANCE — WHO OWNS THE MEANING? Once these relationships start supporting production decisions, ownership becomes critical. Someone has to define which record represents the asset, which machine can perform which operation, which system owns work-order execution state, which system owns quality release, and who approves mappings between maintenance, MES, ERP, and automation records. The answer normally involves several business domains rather than one central IT team. That means the architecture needs clear ownership, source references, timestamps, version history, data contracts, and approval processes. AI can help suggest likely mappings between inconsistent records, but a suggested relationship should not automatically become a governed production fact without evidence and domain validation. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-a-microsoft-mvp-podcast-by-mirko-peters--6704921/support.

    Connectivity Is Not Integration — Why Your Connected Factory Still Can't Answer the Right Questions
  7. 5 Oct

    Why Continuous Improvement Needs Better Data

    Continuous improvement is supposed to create learning that compounds over time. In many factories, however, improvement work still depends heavily on workshops, spreadsheets, isolated reports, and what people remember from the previous shift. A Kaizen event can create visible progress, but a few weeks later the same loss often appears again under slightly different production conditions. The issue is not always the quality of the improvement idea. The bigger problem is that teams often cannot prove whether the countermeasure actually worked, where it worked, and under which conditions it stopped working. WHY KAIZEN IMPROVEMENTS OFTEN DISAPPEAR A workshop creates focus for a few days. Teams map the process, identify waste, assign actions, move tools, change checklists, or adjust handoffs. Then normal production pressure returns. The supervisor has another urgent order, maintenance has another fault, planning changes the sequence, and quality puts another batch on hold. The improvement action remains somewhere in an Excel file or project tracker instead of becoming part of the operating rhythm. The important question is therefore not whether an action was completed, but whether the production condition actually improved. PDCA NEEDS A REAL CHECK STEP Plan, Do, Check, Act sounds simple, but many organizations effectively run Plan, Do, and Move On. PLAN should define a testable problem, the current condition, the expected improvement, and the hypothesis behind the countermeasure. DO means testing the countermeasure under real production conditions while recording enough context to understand what actually happened. CHECK means comparing the expected result with real production evidence. ACT means standardizing the change when the evidence supports it, or adapting, narrowing, or reversing it when it does not.    • Did the loss actually decrease? • Did the problem simply move somewhere else? • Did the change improve availability while damaging quality? • Did it work across different products, crews, and shifts? • Did maintenance, material, scheduling, or another process change influence the result? A single successful production run is not proof. Continuous improvement needs enough evidence to separate a repeatable improvement from a lucky shift. GEMBA AND DATA NEED EACH OTHER Data does not replace Gemba. Operators, supervisors, technicians, planners, and quality teams understand production conditions that systems often cannot capture. A machine record may show a ten-minute stop, while an operator knows that the stop happened because a component felt wrong, a normal material route was blocked, or the previous shift left the station in an unusual condition. At the same time, observation alone shows only one shift, one event, or one version of the problem. Connected operational data makes it possible to test whether an observation repeats across orders, products, machines, shifts, material batches, and longer periods of time.     Gemba helps teams identify where to look and which questions matter. Operational data helps test those questions across the real production pattern. Standard work then carries the learning forward so the next shift does not start from zero. START WITH THE IMPROVEMENT QUESTION One of the biggest mistakes in manufacturing analytics is beginning with the data that happens to be available. A modern production line can generate huge volumes of information from PLCs, sensors, MES systems, ERP, quality systems, maintenance applications, and spreadsheets. More data does not automatically create better decisions. A useful improvement process starts with the production question the team actually needs to answer. Instead of asking “What data do we have?”, ask “What production question are we trying to answer?” A statement such as “changeovers take too long” is still too broad. A better question would be: Why does changeover time vary significantly for the same product family on the same production line? That immediately helps define the context that matters.    • Previous product • Next product • Production order • Resource or line • Tool configuration • Material • Shift or crew • Setup start • Restart time • First acceptable unit • Stable production • Quality results • Machine alarms The goal is not to collect everything. The goal is to collect the smallest set of facts capable of changing the improvement decision. ERP EXPLAINS THE PLAN ERP provides the commercial and planning context around production. It can show planned quantities, routing, customer commitments, material requirements, order priority, and the intended production sequence. That context matters because production conditions constantly change. A countermeasure might genuinely reduce setup time while delivery performance still deteriorates because the production mix changed or planners introduced more frequent product transitions. ERP therefore helps explain what was supposed to run, in what sequence, for which demand, with which routing and materials. But ERP primarily describes intent. It does not necessarily describe what physically happened on the shop floor.   MES EXPLAINS WHAT ACTUALLY RANThe Manufacturing Execution System fills part of that gap. MES can provide the execution history behind an order, including actual operation start and finish, produced quantity, rejects, holds, rework, resources, operator transactions, material consumption, traceability, and reason codes. This allows improvement teams to connect losses with real orders and operations instead of relying on memory or daily averages.    MES data still needs interpretation. Transactions may be entered late, different crews may use reason codes differently, and a timestamp may represent when an operator confirmed something instead of the exact physical moment when it happened. The system provides evidence, but the process gives that evidence meaning. MACHINE AND IOT DATA EXPLAIN THE PHYSICAL PROCESS When teams need to understand what happened inside an operation, machine data becomes important. PLC and IoT signals can expose machine states, cycle times, alarms, speed, temperature, pressure, interlocks, motor load, restart behavior, and time to stable production. MES may show that an operation restarted at a particular time, while machine data explains what happened during the minutes before stable output returned.  • Repeated alarms • Reduced speed after restart • Temperature recovery • Manual adjustments • Interlocks • Unstable cycle times Machine data without production context can still be misleading. An alarm becomes much more useful when it can be connected to the work order, product, operation, resource, tool condition, material, and quality result surrounding the event. THE SHOP FLOOR ADDS MEANING Operators, maintenance technicians, supervisors, and quality teams fill the gaps that automated systems cannot. A reason code such as “material issue” may describe very different situations in practice. The material may have arrived late, behaved differently, carried an incorrect label, been damaged, or created a downstream problem that only became visible later. Structured codes help categorize events. Human context helps explain them. Data capture therefore needs to fit the reality of production instead of interrupting it. The useful question is not how much information an operator can enter, but what is the smallest human input that would make the next improvement decision better.     YOU NEED A SHARED FACTORY LANGUAGE ERP, MES, maintenance systems, historians, and spreadsheets can all describe the same production event differently. One system may call a resource “Line 3,” another may use “LINE03,” maintenance may track several separate assets inside the line, and a historian may still use an old PLC tag. All of these identifiers can technically be correct while still making cross-system analysis unreliable. The same problem applies to definitions. “Production complete” might mean the machine finished, MES posted the quantity, quality released the batch, the product was packed, or the order was ready to ship. A dashboard cannot decide which definition is correct. The organization has to define that shared meaning. Why Continuous Improvement Need… THE DATA MODEL BEHIND CONTINUOUS IMPROVEMENT A useful manufacturing data model preserves meaning as information moves between systems. Products, batches, work orders, resources, process steps, shifts, tools, materials, quality outcomes, maintenance conditions, production events, and timestamps need managed relationships so teams do not rebuild the same logic every time they investigate a problem. • Product • Product family • Work order • Batch • Process step • Resource • Machine or asset • Shift • Tool • Material • Quality result • Maintenance condition • Production event • Time Definitions also need ownership and versioning. Downtime, scrap, rework, good count, target rate, and changeover duration should not quietly mean different things in different reports. Products change, recipes change, tools change, machines are upgraded, routes change, and approved target rates change. Without versioning, today's process rules can accidentally be applied to historical production data. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-a-microsoft-mvp-podcast-by-mirko-peters--6704921/support.

    Why Continuous Improvement Needs Better Data
  8. 2 Oct

    IoT Hub Message Routing vs Event Grid — Why Telemetry and Events Are Not the Same Problem

    A temperature reading, a vibration sample, a machine cycle, and a device disconnect may all be described as events, but they do not represent the same architectural problem. In industrial IoT and manufacturing environments, confusing continuous telemetry with discrete events can create noisy workflows, incomplete production histories, unnecessary processing, and systems that react without enough context. In this episode, we break down the architectural difference between Azure IoT Hub Message Routing and Azure Event Grid by following a realistic manufacturing scenario. A press line continuously sends temperature, vibration, cycle count, energy consumption, and machine-state information through an industrial gateway. Those measurements create an operational history that engineers, data teams, maintenance teams, and production systems may need to analyze later. A device disconnect is different because it represents a change that may require another system or person to react. TELEMETRY IS A RECORD, NOT AN ALERT Telemetry represents repeated measurements over time. A single temperature value or vibration measurement usually tells you very little on its own. The real information exists in the sequence: how quickly values changed, what the machine was doing at that moment, what happened before a stop, whether measurements disappeared during a network interruption, and whether the same behavior appeared in earlier production runs. Typical industrial telemetry includes: • Temperature, vibration, pressure, energy consumption, and current draw • Machine states such as running, idle, stopped, or faulted • Cycle counts, production counters, and process measurements • Source timestamps, device identifiers, sequence numbers, and correlation information Those records may later support condition monitoring, quality investigations, energy analysis, OEE calculations, Microsoft Fabric analytics, Power BI reporting, and production optimization. That is why telemetry needs retention, replay, duplicate handling, independent consumers, and a reliable way to reconstruct the production timeline. IOT HUB MESSAGE ROUTING AS THE TELEMETRY DATA PLANE Azure IoT Hub provides the controlled device-to-cloud boundary. Devices and gateways authenticate with their own identities, send device-to-cloud messages, maintain device-management state, and can participate in controlled cloud-to-device communication. Once a telemetry message reaches IoT Hub, Message Routing determines where that data should go. Routing can inspect message properties, system properties, parts of the message body, and device twin information. This makes it possible to separate production telemetry, energy measurements, diagnostics, or other message classes before they reach downstream consumers. A common architecture might look like this: Industrial gateway → Azure IoT Hub → Message Routing → Event Hubs or Storage → Processing → Microsoft Fabric. One consumer may perform near-real-time analysis while another keeps a raw archive. A third consumer may prepare curated operational data for Microsoft Fabric. Each consumer can work independently without turning every telemetry reading into a workflow invocation. WHY ORDERING MATTERS Industrial telemetry is particularly sensitive to sequence. Imagine a machine reporting that it entered a running state, then transmitting several cycle counts, followed by a process deviation and finally a stopped state. If those records are reconstructed incorrectly, a downstream system could conclude that the machine produced parts while stopped or that a process deviation happened after production had already ended. The same problem affects downtime calculations, OEE, production counts, and condition monitoring. You therefore need to distinguish between when the source observed something, when IoT Hub received the message, and when a downstream system processed it. A robust telemetry architecture should therefore consider: • Source timestamps and cloud receipt timestamps • Stable partitioning appropriate to the asset or workload • Message IDs or sequence numbers for duplicate detection • Idempotent consumers capable of handling at-least-once delivery Network interruptions make this especially important. A gateway may buffer telemetry and send it when connectivity returns, which means Azure arrival time may be much later than the actual machine timestamp. EVENT GRID SOLVES A DIFFERENT PROBLEM Azure Event Grid is designed around publish-and-subscribe notifications. Instead of continuously reconstructing the state of a machine from thousands of readings, Event Grid tells interested systems that something changed and gives subscribers an opportunity to react. Examples in an IoT environment include device creation, device deletion, connection, disconnection, or carefully selected telemetry-derived conditions. A device-created event might trigger an asset onboarding process. A device-disconnected event might start a technical investigation. A detected engineering condition might trigger a maintenance workflow. Typical subscribers include: • Azure Functions • Logic Apps • Webhooks • Security workflows • Asset-management systems • Operational applications The fundamental architectural difference is simple: telemetry asks what an asset has been doing, while an event asks what changed and whether something should react. EVENTS SHOULD START INVESTIGATIONS, NOT DEFINE REALITY Event Grid should generally be treated as a notification mechanism, not as the final authoritative state of the physical world. Event delivery can be repeated, and events are not something a subscriber should blindly interpret as the final current state without checking. A device-disconnected event should therefore usually trigger a state check. An Azure Function might verify the current device state, inspect recent telemetry, check relevant registry information, and then decide whether the investigation should remain open. Handlers should be designed around: • Idempotent processing • Current-state verification • Event identity and timestamps • Clearly defined ownership of the resulting action This matters because duplicate events should not create duplicate tickets, duplicate alerts, or conflicting operational records. A DEVICE DISCONNECT DOES NOT MEAN THE MACHINE STOPPED One of the most important distinctions in industrial IoT is the difference between cloud connectivity, data-collection health, and production state. If an industrial gateway disconnects from IoT Hub, the cloud has lost visibility into that gateway. That does not automatically mean that the physical machine stopped. The PLC may continue controlling the equipment locally while the gateway temporarily loses connectivity. Production may continue normally, and the gateway may even buffer telemetry and upload it later. The opposite can also happen: a gateway may remain connected to Azure while its connection to the PLC or local equipment has failed. A useful architecture therefore separates cloud connection state, gateway health, machine production state, and MES work-order state. Only by combining those sources can the business determine whether a technical connectivity issue actually affected production. FILTERING IN IOT HUB VS FILTERING IN EVENT GRID Both technologies support filtering, but the purpose is different. IoT Hub Message Routing filtering answers which operational messages should enter a specific data path. Event Grid subscription filtering answers which notifications a particular subscriber should receive. For example, production telemetry may go to one Event Hubs stream while energy data goes to another destination. At the same time, a support workflow may subscribe only to disconnected events from a particular group of gateways. Confusing those two types of filtering often results in an architecture where every subscriber creates its own interpretation of the telemetry stream. A cleaner design keeps broad telemetry classification governed centrally and keeps Event Grid subscriptions focused on clearly defined reactions. THE MANUFACTURING CONTEXT LIVES OUTSIDE THE MESSAGE BUS Neither IoT Hub nor Event Grid knows what a machine means to the business. A device ID may identify a gateway, but it does not inherently know which production line the gateway belongs to, which machine it observes, which work order is running, whether a stop is planned, or whether production is already at risk. That context usually comes from multiple systems. MES provides execution context such as work orders, operations, recipes, production state, and shift information. ERP provides demand, commitments, inventory, and planning information. An asset model connects devices, gateways, PLCs, machines, cells, lines, and sites. In more advanced architectures, a digital twin or knowledge graph can help maintain those relationships. The result is a more reliable operational picture in which telemetry explains what the equipment reported, MES explains what production was doing, ERP explains why it matters, and the asset model explains how the technical components relate to the physical plant. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-a-microsoft-mvp-podcast-by-mirko-peters--6704921/support.

    IoT Hub Message Routing vs Event Grid — Why Telemetry and Events Are Not the Same Problem

About

M365.FM is a podcast about Microsoft 365, Microsoft Copilot, AI, Modern Work, security, governance, Power Platform, Azure, and the technologies shaping the future of work.Hosted by Microsoft MVP Mirko Peters, M365.FM brings together Microsoft MVPs, Microsoft employees, product experts, architects, developers, and community leaders from around the world.Each episode goes beyond announcements and hype to explore what Microsoft technologies mean in practice. From Microsoft 365 Copilot and AI agents to Teams, SharePoint, Power Platform, Microsoft Fabric, Entra, Purview, security, governance, adoption, and automation, M365.FM focuses on real-world experience, implementation, strategy, and lessons learned.Expect expert interviews, technical deep dives, practical explainers, and conversations with people building, implementing, and shaping the Microsoft ecosystem.If you work with Microsoft 365, Copilot, AI, Modern Work, or the Microsoft Cloud, M365.FM helps you understand what matters, what works, and what is coming next.Hosted by Mirko Peters, Microsoft MVP. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-a-microsoft-mvp-podcast-by-mirko-peters--6704921/support.

You Might Also Like