Rishi Sapra
Rishi Sapra

SQL Bits 2024 – Power BI and Fabric Governance – Going from the skies to the ground! (100 Minute session)

SQL Bits 2024 - Power BI and Fabric Governance – Going from the skies to the ground! (100 Minute session)

When

March 23, 2024    
10:10 am - 11:00 am

Running since 2007 and now with over 3,000 attendees, SQL Bits has become the largest Data Platform conference in the world, running annually and featuring 200 world class speakers, 300+ hours of content, and the best networking opportunities in the industry. It features the world’s best experts in the Microsoft data space presenting and attending from across the world.

​

Rishi presented one of the new 100 minute sessions  covering how to Govern and manage a large-scale Fabric/Power BI estate, specifically:

• Defining objectives for Governance, based on the Power BI adoption roadmap and data mesh/Modern Analytics Governance At Scale (MAGS) principles.

• Considering the scope of workspaces and artefacts in your tenant, and how to actively manage/monitor this using admin insights/REST APIs to capture inventory and activity logs.

• Review of tenant admin settings – how you decide what these should be (aligned to a set of corporate security principles/requirements) and how you can manage the groups of individuals who have access to particular settings/functionality through an approval-based workflow.

• Understanding the components and management of a “Managed workspace” architecture (where your Enterprise BI/Data artefacts are hosted, typically on Power BI Premium per Capacity) including AAD group-based access-control, Application Lifecycle Management, centralised data management (e.g. Dataflows/Datamarts/Shared Datasets) and performance management.

• Roles and Responsibilities of teams/individuals across the organisation, including a Centre of Excellence (focused on enablement) and developer teams.

• How to set up ongoing monitoring and support for Power BI/Fabric, including development of an Estate monitoring solution, using the Premium Capacity Metrics app and enabling your support/COE teams to effectively deal with issues.

 

The content of this session is covered in the Fabric and Power BI Governance e-learning course

Rishi Sapra