Power Automate: Get support for normalized schema import for data ingestion
Customers with existing data pipelines or data products in data mesh mostly want to stick to normalized, efficient forms such as star schema. Power Automate Process Mining currently requires you to transform the event log into a single-table form, where attributes with small cardinality are duplicated. Support for star schema reduces storage volumes and speeds up ingestion performance. Most systems of record have data stored in data structures that allow you to easily extract information about the analyzed entity (case-level data) and historical changes on those entities (event-level data). The attributes are also stored in a normalized form. The single-table approach to event log creation requires you to do inefficient transformations. With this feature, Power Automate Process Mining supports the case-event entity-based data structure plus a normalized form of attributes. This speeds up the ingestion process in both the transformation and import to process model phases and reduces the storage capacity needed. Learn More
The post Power Automate: Get support for normalized schema import for data ingestion appeared first on M365 Admin.
Published on:
Learn more
Related posts
Microsoft Power Automate | 2026 Release Wave 1
Power Automate: sort Function
Power Automate's sort function arranges arrays in ascending order by value or property. Learn usage tips, the string-vs-number gotcha, and how...
AI-Powered Approval System Using Copilot in Power Apps and Power Automate Flow
Modern approval processes are often slow, manual, and inconsistent, leading to delays, policy violations, and poor decision-making. In this so...
Power Automate: Office 365 Outlook - When a new event is created Trigger
The "When a new event is created" trigger monitors your Outlook calendar in Power Automate. Learn about UTC gotchas, duplicate triggers, and t...
[REDACTED] message when turning on a Power Automate flow
We all like useful error messages. How about the [REDACTED] Message when you turn on a flow? In this post you will find the steps to fix this ...
Power Automate: Do Until Action
The "Do Until" action loops in Power Automate until a condition is met. Learn its limits, why it always runs once, and how to avoid runaway lo...
Use Inventory to find your Power Automate flow?
How often do you want to find a flow, but you can’t remember which environment you created the flow in? It can be quite a
Power Automate: reverse Function
Learn how to use the Power Automate reverse function to flip the order of items in an array. Includes examples with strings, objects, and sort...
Why you need the question mark operator in Power Automate expressions
Learn why the question mark operator in Power Automate prevents runtime errors when accessing properties that might not exist, and how to use ...