Power BI Administration and Governance

Ásgeir Gunnarsson Data Platform MVP
18. november 2021 09:00
18. november 2021 16:00
Skelbækgade 3A, København V   Vis kort

4.000 DKK

På lager



In this training session we will cover everything you need to know as a Power BI administrator or Power BI responsible. We will use theory and practice to learn concepts and apply them.

We will provision a Power BI environment; we will look at the main settings and figure out which of them are important and how they should be set according to best practices. We will then setup Power BI premium and look through the administration options when it comes to dedicated capacity. We will investigate the role of the Enterprise Gateway, set it up, configure it and talk about how to administer it. We will look at Power BI governance and see how you can set governance strategy, create processes and roles and lastly but not least how you can monitor your Power BI environment.

Who is this training for?

This training is aimed at Power BI Administrators, lead developers, governance responsible and other with interest in Power BI Administration and Governance and in the concepts and best practices of the subject.

There are no pre-requisites to join the course but ideally you have a basic understanding of Power BI. If you don´t you will be able to complete the course but some of the Administration concepts might not be as relatable.

How is the training delivered?

The training format is classroom training where theory and practice are interchanging. We will introduce topics and then do exercises to enforce the theory. If you are an administrator of a Power BI tenant, you can choose to do the exercises on your own tenant or choose to do them on our practice tenant.

What will you take away from the training?

When you have completed the course, you will have a deep understanding on:

  • What a Power BI tenant is and how it´s organized
  • What the Power BI Administrator can and cannot do
  • How to setup a tenant and maintain it
  • What the important settings are and how to maintain them
  • The difference between Power BI Pro, Power BI PPU and Power BI Premium from the Administration and governance perspective
  • How to administer the Power BI On-Premises Gateway
  • What to focus on when it comes to governing Power BI
  • What processes give value and how to define them
  • What and how to monitor when it comes to Power BI

Besides the knowledge of the above topics, you will come away with examples of process documents and code to monitor your Power BI tenant.


  1. Introduction
  2. Power BI Administration
    1. Understanding the Power BI Administrator Role
    2. Establishing a Power BI Environment
    3. Admin Portal
    4. Office 365 settings
  3. Power BI Premium
    1. Provisioning Premium Capacity
    2. Administrating Power BI Premium Capacity
  4. Enterprise Gateway administration
    1. Setup the Enterprise Gateway
    2. Administrate the Enterprise Gateway
  5. Introduction to governance
  6. Governance strategy
    1. Four pillars of Power BI Governance Strategy
  7. Best practices
    1. Development process
    2. Publishing process
    3. Sharing Process
    4. Security Process
    5. Naming Standards
    6. Tenant Settings
    7. Gateway process
    8. Tying it all together
  8. Monitoring
    1. Monitoring Power BI artifact inventory using REST API
    2. Monitoring actions using Audit log
    3. Monitoring the Enterprise Gateway
    4. Monitoring capacities
    5. Using PowerShell to collect monitoring data
  9. Training
    1. User groups
    2. Types of training
    3. Delivery method
    4. Training content
    5. Using Office 365 API, Power BI Audit Log and Microsoft Flow to find trainees
  10. Roles
    1. What roles are needed
    2. Role definitions
    3. Discussion: What roles are necessary, and do they need allocation
  11. Wrap up