SQLBits 2020

Performance tuning Power BI dataset refresh

So your dataset is taking too long to refresh. What can you do? In this presentation you’ll learn about all the different components that can contribute to slow refresh performance such as the data sources you’re using,

So your dataset is taking too long to refresh. What can you do? In this presentation you’ll learn about all the different components that can contribute to slow refresh performance such as the data sources you’re using, the Power Query engine, the Analysis Services engine inside Power BI and the Power BI on-premises data gateway. You’ll learn useful tips and tricks on how to tune them and some common mistakes to avoid.

Speaker

Chris Webb is a member of the Power BI Customer Advisory Team at Microsoft.

Chris Webb's Sessions

Query folding in Power Query

Performance Tuning Power Query And Dataflows In Power BI

Creating Tables In Power Query And M Using #table()

Power BI: Business Intelligence Strategy, Vision, & Roadmap

Performance tuning Power BI dataset refresh

Advanced analytics features in Power BI

Top tips for the accidental Power BI administrator

Introduction To Dataflows In Power BI

Using Analysis Services MD as a Data Source for Power BI

Introduction to Azure Analysis Services

Building A Reporting Solution Using Power Query

Power Query: Beyond The Basics

DAXMD: SSAS Multidimensional meets DAX and Power View

Advanced Security with Analysis Services Multidimensional

Fun with Scoped Assignments in MDX

Implementing Common Business Calculations in DAX

Common Analysis Services design mistakes and how to avoid them