SQLBits 2020

Whats Going On in My Power BI Environment?

As Power BI is a self-service tool, it can be hard for administrators to monitor it. Power BI is fast improving in this context but there still isn’t a consistent way of monitoring it.

As Power BI is a self-service tool, it can be hard for administrators to monitor it. Power BI is fast improving in this context but there still isn’t a consistent way of monitoring it. There are compliance, governance, performance, and implementation questions to consider. Who is creating content, how is it being distributed, what data is being used, how long does the refresh take and how is it changing, who has a trial license, and what report is the most used? These are just some of the questions you as an administrator of Power BI might want to get answers to. 

In this session, we will look at how you can find those answers by monitoring Power BI. We will look at the Power BI Audit log for usage, license, and other audit information. We will look at what the Power BI API can show us about data sets, refresh history, Enterprise Gateway information, premium capacity, and artifact inventory. The audience leave the session ready to start their own monitoring of all or some of the topic

Ásgeir Gunnarsson's other proposed sessions for 2026

Best Practices for Sharing Power BI Content with External Users - 2026

Data Quality Validations in Fabric Spark - 2026

Find the Spark as a SQL data warehouse developer - 2026

From Chaos to Control: Orchestrating Lakehouse Workloads in Microsoft Fabric - 2026

From Chaos to Control: Orchestrating Lakehouse Workloads in Microsoft Fabric Part 1 - 2026

From Chaos to Control: Orchestrating Lakehouse Workloads in Microsoft Fabric Part 2 - 2026

Workspace strategy for Lakehouse/Warehouse in Microsoft Fabric - 2026

Panel Debate: Real-World Microsoft Fabric Administration - Lessons from the Trenches - 2026

Ásgeir Gunnarsson's previous sessions

Power BI Governance quick start

For many the mention of governance gives them images of massive effort and inconvenience for themselves and end-users. It´s a hindrance and waste of time. But it doesn´t have to be that way. In this session we will talk about how we can start to tackle Power BI governance. We will look at few things you can get started with very quickly that will get you far in setting up your governance strategy. We will look at things such as documentation, roles and monitoring. The hope is that you go back to your organization with a clear picture of where to start and a better feeling on governance.

5 Power Automate flows that could give immediate value in your organization

In this session we will demonstrate how to create value fast with Power Automate. We will do this by showing 5 types of flows that can give value with little development effort

Managing Power BI workspaces

This session will help you find the best strategy for managing your Power BI workspaces. Should you go for as much automation as possible or do careful manual process? Should you have few people controlling everything or should everyone do as they want? All this and more you will find in this session.

Whats Going On in My Power BI Environment?

As Power BI is a self-service tool, it can be hard for administrators to monitor it. Power BI is fast improving in this context but there still isn’t a consistent way of monitoring it.

Power BI Governance overview

Governance of your Power BI environment is very important. Setting up structure around it will allow developers (IT or business) to develop Power BI content the right way, first time as well as aid administrators

Impact of weather on English Premier League in Power BI

By using open data and web scraping in Power BI we will examine if weather has an impact on games in the English Premier League. We will look at the advantages and disadvantages of using open data and web page data how Power BI works with it.