Unlocking Data Governance with Microsoft Fabric and Purview

1. Understanding the Core Components :

• Microsoft Fabric + Microsoft Purview provide a unified approach to data governance.
• Helps in access control, classification, and data discovery across the organization.
• Core tools used: Data Map and Unified Data Catalog.

2. Connecting Fabric to Purview :

• Create a collection in the Data Map >> serves as a control point for metadata access.
• Use a clear naming convention and keep all Fabric assets under a single collection for better organization.

3. Registering the Data Source :

• Navigate to Data Source >> Register.
• Select Microsoft Fabric (includes Power BI).
• Choose the correct domain and collection before registering.
• This step links Fabric with Purview.

4. Creating Your First Scan :

• After registration, initiate a scan.
• Assign a name to the scan.
• Optionally exclude personal workspaces (recommended for clarity).
• A System Assigned Managed Identity (SAMI) is automatically created for metadata access.

5. Setting Up Fabric Access for Purview :

• Go to Microsoft Fabric Admin Portal.
• Update Tenant Settings:
  • Enable read-only admin APIs.
  • Enable enhanced API responses.
• Add the security group that contains the SAMI created earlier.

6. Creating a Security Group in Azure :

• In Azure Active Directory:
  • Create a dedicated security group for Purview–Fabric integration.
  • Follow a clear naming convention.
  • Assign ownership to yourself.
• Link this group back in Fabric.
• Allow a few minutes for changes to propagate.

7. Testing the Integration :

• In Purview, click Test Connection.
• If successful, integration between Fabric and Purview is ready.

8. Initiating a Data Scan :

• Choose Full Scan or Selective Scan.
• Launch the scan and monitor progress in real time.
• Scans usually complete within minutes.

9. Analyzing Scan Results :

• View summary report: number of assets discovered + data classifications applied.
• Option to download a log file for detailed troubleshooting.

10. Exploring Your Data :

• Once scanned, assets in Fabric are discoverable inside Purview.
• Users can:
  • Browse assets.
  • Request access.
  • Collaborate with teams more effectively.

11. Publishing Data Products :

• Use Purview to build data products.
• Benefits:
  • Ensures reusability.
  • Maintains security and governance.
  • Supports cross-team collaboration.
• Helps establish a long-term governance strategy.

12. Wrapping Up :

• Integration of Fabric with Purview = streamlined data governance.
• Enhances clarity, structure, and efficiency for managing data assets.
• For deeper insights, check Microsoft Purview official documentation.