SQLBits 2020

My Power BI report is slow: what should I do?

Use Performance Analyzer and DAX Studio to find the performance bottleneck in a slow Power BI report.

You created a wonderful Power BI report, but when you open it you wait too much time. Changing a slicer selection is also slow. Where should you start analyzing the problem? What can you do to optimize performance?

This session will guide you in analyzing the possible reasons for a slow Power BI report. By using Power BI Performance Analyzer and DAX Studio, you will be able to determine whether you should change the report layout, or if there is something in DAX formulas or in the data model that is responsible for the slow response.

At the end of this session, you will understand how to locate a performance bottleneck in a Power BI report, so you will focus your attention on the biggest issue.

Marco Russo's previous sessions

Aggregations in Power BI

Introduce Power BI aggregations with practical examples, evaluate pros and cons, and learn how to use alternative approaches by using DAX to control the aggregation used.

Using ALLEXCEPT or ALL/VALUES?

Learn when to use ALL / VALUES instead of ALLEXCEPT in DAX calculations.

Understanding window functions in DAX

Introduction to DAX window functions and apply semantics through several examples to understand their capabilities and performance.

Power BI Performance Analyzer crash course

Learn how to use Performance Analyzer in Power BI to get a first idea of performance bottlenecks in Power BI reports.

VertiPaq Analyzer crash course

Introduce VertiPaq Analyzer features in DAX Studio and as a library available in other tools.

My Power BI report is slow: what should I do?

Use Performance Analyzer and DAX Studio to find the performance bottleneck in a slow Power BI report.

Time Intelligence in Power BI

Create the right Date table and use DAX time intelligence functions or custom filters to get the desired calculation aggregating and comparing data over time.

VertiPaq Analyzer crash course

Learn how to read the information provided by VertiPaq Analyzer 2.0 and optimize data models in Power BI, Analysis Services, and Power Pivot.

Different types of many-to-many relationships in Power BI

Clarify differences between many-to-many and weak relationships in Power BI

DAX Best Practices

Best bractices in DAX formulas from real world experience.

Power BI Dashboarding

Power BI offers new features for creating dashboards on the cloud. In this session, you will learn how to create data models, display visualizations and synchronize cloud data with on premise data sources.

SSAS Tabular from the Trenches

In this session, we will share some of the hard lessons learned from the first large deployments in Analysis Services Tabular.

Learn ready-to-use DAX patterns improving development speed of Power Pivot solutions. Good also for SSAS Tabular developers.

Power Query in Modern Corporate BI

Explore Power Query features to import data from existing Corporate BI systems.

Modern Data Warehousing Strategy

This session will discuss what a modern strategy for data warehousing can be in this era, considering how the use of technologies like PowerPivot or Analysis Services Tabular affect the way you should model your data.

Create a Data Model in BISM Tabular

In this session you will see how to create a BISM Tabular data model from scratch, providing the required metadata in order to improve user experience navigating the data model by using client tools like Excel PivotTable and Power View.

Analysis Services Advanced Best Practices

This dense hour of presentation will cover design techniques to leverage cube features that also consider possible maintenance of the database structure over time.

BISM Introduction

Introduce the features of BISM (BI Semantic Model), the new engine that will be available in Analysis Services "Denali".

Vertipaq vs OLAP: Change Your Data Modeling Approach

In this session we will introduce the new modeling capabilities of Vertipaq, showing how the same scenarios can be modeled in both Multidimensional (MOLAP) and Tabular (Vertipaq), looking at how to enable your data warehouse to support both.