Scalable Data Management with Microsoft Fabric and Microsoft Purview

Piethein Strengholt
21 min readApr 8, 2024

Managing vast quantities of data can be a significant challenge. It requires an entire organizational shift towards federated data management and a product-oriented culture. Complex architectural concepts like data mesh can make these cultural and organizational changes seem overwhelming. Hence, critics frequently regard these concepts as overly theoretical and impractical. To combat this perception, it’s crucial to approach these transformations with a clear, practical strategy.

Interestingly, many organizations view data mesh as an architectural concept for scalable data management. The image above illustrates how the logical data mesh architecture aligns with Microsoft services. The federated computational governance layer will be implemented using Microsoft Purview, while the data products will be developed using Microsoft Fabric.

In this blog post, I aim to demonstrate a practical data transformation using Microsoft Fabric and Microsoft Purview. The target audience includes executives, architects, analysts, and compliance and governance personnel who are interested in creating a comprehensive data platform.

For this exercise, I’ll use a hypothetical airline organization called Oceanic Airlines as an example, but the narrative is grounded in the real-world experiences of contemporary enterprises already utilizing these Microsoft services. It’s important to note that embarking on a data journey to identify domains and construct data products at a large scale is intricate. This process entails nuances and comes with organizational and cultural shifts. Moreover, it’s essential to understand that there’s no universal approach that fits all scenarios.