22-25 April 2026 
SQLBits 2017
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.
Have you ever wondered if there are scored more goals when it rains or if Stoke wins more games on cold weekday evening at bet265 stadium? This session shows how you can use open data sources and web pages to gather data.
How you can then manipulate and extend it and finally report on it. We will look into how you can use data from Azure data market or other open source and combine it with data from web pages to create the dataset you need.
When we have our dataset we will manipulate and extend it using M and DAX so that we can get meaningful insights from it. We will then dive into the data to see if there is anything to report.
In this end to end Power BI Desktop demo we will use fun data that many can relate to as the English Premier League is one of the most popular football leagues in the world. The audience will take away many nuggets of information as they see how a real world example could look like. I will share with them all the obstacles and learning I got when creating this report so they will see both the limitation of Power BI Desktop and open data as well as its strength. First of all the audience will learn how to use Power BI Desktop to create something real with fun data.
Both the data acquisition and manipulation as well as the reporting is covered in this demo rich session. The audience will learn about Power BI desktops strength and weaknesses as well as the benefits and potential problems with using open data and web pages as source.
In the end the Power BI Desktop file will be available to download for the audience.
How you can then manipulate and extend it and finally report on it. We will look into how you can use data from Azure data market or other open source and combine it with data from web pages to create the dataset you need.
When we have our dataset we will manipulate and extend it using M and DAX so that we can get meaningful insights from it. We will then dive into the data to see if there is anything to report.
In this end to end Power BI Desktop demo we will use fun data that many can relate to as the English Premier League is one of the most popular football leagues in the world. The audience will take away many nuggets of information as they see how a real world example could look like. I will share with them all the obstacles and learning I got when creating this report so they will see both the limitation of Power BI Desktop and open data as well as its strength. First of all the audience will learn how to use Power BI Desktop to create something real with fun data.
Both the data acquisition and manipulation as well as the reporting is covered in this demo rich session. The audience will learn about Power BI desktops strength and weaknesses as well as the benefits and potential problems with using open data and web pages as source.
In the end the Power BI Desktop file will be available to download for the audience.
Speakers
Á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.