Welcome

Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk . Microsoft Data Platform MVP

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein



Thursday, 6 August 2026

Governance should travel with the Data: Microsoft Purview Data Sharing

One of the more frustrating characteristics of traditional data governance is that it often becomes less effective at the exact moment information starts to create value. Organisations invest significant effort in cataloguing information, defining business terminology, assigning ownership, improving quality and establishing governance controls. Within a governed environment, confidence begins to grow because people understand what data exists, how it should be used and who is responsible for it. The challenge emerges when that information needs to be shared.

Historically, sharing data has often created a new copy of the problem alongside a new copy of the data. Information is extracted from a source system, copied into another platform and then distributed to a different department, partner or project team. While the immediate requirement has been satisfied, something important is frequently lost along the way. The governance context associated with that information does not always travel with it.

Definitions become disconnected from the business glossary. Ownership becomes less obvious. Security controls may differ between environments. Lineage becomes harder to follow. Before long, multiple versions of the same information exist across different locations, each carrying slightly different assumptions about how it should be managed.

Many organisations have spent years attempting to reduce the number of data silos within the business, only to discover that sharing data can be one of the fastest ways to create new ones.

This creates an important governance challenge.

Data only delivers value when people can access and use it. Restricting access to everything is rarely a practical solution. At the same time, uncontrolled sharing introduces risk, duplication and inconsistency. Effective governance requires a balance between enabling access and maintaining control.

This is where Microsoft Purview Data Sharing becomes particularly valuable.

Rethinking what it means to Share Data

When people hear the phrase "data sharing", they often assume it means moving data from one place to another.

Modern governance increasingly takes a different approach.

Rather than distributing copies of information throughout the organisation, the goal is to provide controlled access to trusted datasets while keeping the information where it already resides. Instead of sharing the asset itself, organisations increasingly focus on sharing access to the asset.

The distinction is more significant than it first appears.

A copied dataset immediately begins diverging from its source. Updates may occur in one location but not another. Governance controls may evolve independently. Users consuming the copied data may no longer have visibility of ownership, quality metrics or policy controls that existed within the original environment.

Providing access to the governed source avoids many of these problems because users remain connected to the same underlying asset.

The data and governance remains in one place. The organisation maintains a single version of the truth.

Why Data Sharing depends on Discovery and Trust

By the time an organisation begins sharing information more broadly, much of the work described in the previous articles has already become important.

Sharing trusted data assumes that trusted data has first been identified.

The Unified Catalog helps users discover available datasets. Business Glossary terms ensure there is a common understanding of what those datasets represent. Lineage helps explain where information originated and how it has been transformed. Data Quality provides confidence that the information meets expected standards.

Without those foundations, sharing simply distributes uncertainty more widely.

In many respects, governance capabilities become more valuable as data sharing increases because a larger audience needs confidence in the information being consumed. Users receiving access to data rarely have the benefit of local knowledge from the teams that originally created it. Governance provides the context that helps those users understand what they are accessing.

For this reason, sharing should not be viewed as a standalone capability. It is the outcome of many governance disciplines working together.

Governance should not end at the department boundary

One of the more common challenges within large organisations is that governance maturity often varies significantly between business areas.

Some domains have established ownership, clear definitions and strong stewardship practices. Others remain heavily dependent on local knowledge and informal processes. Sharing information across those boundaries can expose differences that were previously invisible.

A finance team may confidently share information with another department, only to discover that business definitions are interpreted differently elsewhere. Regulatory requirements understood within one team may not be obvious to another. Information classified as sensitive in one context may be treated differently in another.

These situations are rarely caused by poor intentions. More often they reflect the complexity of modern organisations.

A well-governed sharing model helps address this challenge because governance travels alongside the data. Users receiving access are not simply obtaining rows and columns. They are gaining access to ownership information, classification context, business definitions and other governance artefacts that help explain how the information should be interpreted and managed.

This creates a more consistent experience for both providers and consumers of data.

The Role of Data Policy

Sharing information safely ultimately depends on policy.

In the previous article, I explored how Data Policy moves governance from documentation into operational control. Data Sharing builds on the same principle.

Not everybody should have access to every dataset. Access decisions should reflect business need, sensitivity, ownership and organisational policy. As governance programmes mature, manually managing these decisions becomes increasingly difficult, particularly when information needs to be shared across departments, projects or external organisations.

Microsoft Purview helps organisations apply governance controls consistently through integrated policy management. Data can be shared according to rules that reflect the classifications, ownership structures and governance requirements already established elsewhere within the platform.

The important point is that governance is not being recreated at the point of sharing. It is being reused.

The policies that protect information within the organisation continue to provide value when that information is shared more broadly.

Supporting collaboration without creating new silos

The tension between collaboration and control has existed for as long as organisations have managed information.

Too much restriction reduces value because people struggle to access the information they need. Too little control increases risk and often leads to duplication, inconsistency and fragmented data landscapes.

Successful governance programmes recognise that the objective is not to prevent sharing. The objective is to make sharing safe, consistent and transparent.

This is particularly important as organisations invest in data products, cross-functional analytics and AI-driven initiatives. These capabilities depend on information flowing between teams, domains and systems. Value is increasingly created through reuse rather than isolation.

Data Sharing supports this by helping organisations move away from copying information and towards sharing governed access to trusted assets.

The Final Step in the Governance Journey

The earlier articles in this series focused on establishing visibility, building trust, operationalising governance and understanding how governance performance can be measured. Data Sharing brings those capabilities together by allowing governance to support one of the most important objectives of any data programme: enabling people to use information confidently across organisational boundaries.

This is an important distinction because governance is often perceived as something that restricts access to data. In reality, good governance should achieve the opposite. By creating trust, clarity and accountability, it becomes easier for organisations to share information safely rather than harder.

Ultimately, the success of a governance programme should not be measured by how effectively it controls data. It should be measured by how effectively it enables trusted use of data across the organisation.

Because the real value of governance is not found in catalogues, glossaries, dashboards or policies.

It is found in the confidence that allows people to use information, collaborate with others and make better decisions without creating new risks or new silos along the way.


No comments:

Post a Comment

Note: only a member of this blog may post a comment.