Topic: Optimization

       14 videos of 35 posts
video –

Aggregations in Power BI

Aggregations have been introduced in 2018 in Power BI, as an optimization technique to manage large tables. By providing pre-aggregated tables, you can highly improve the performance of a Tabular data model. In this session we introduce the concept of…  Watch now

video –

Power BI DAX optimization examples

How can you optimize your DAX expressions? In this session, we’ll analyze DAX expressions and Tabular models, then utilize DAX Studio and the VertiPaq model to explore how to optimize them. While most optimizations are the direct application of best…  Watch now

video –

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

You have created a wonderful looking Power BI report, but when you open it you find it is not rendering as fast you want. This session covers where should you start analyzing the problem and what can you do to…  Watch now

video –

DAX Studio 2.7 – Improved Debug Experience

DAX Studio 2.7 largely improved the debug experience by adding several feature described in this video: Tooltips for column statistics, capture all queries, and generate dependent measures.  Watch now

video –

DAX Studio 2.1 – New Features

DAX Studio 2.1 has new important features to analyze query plans and find bottlenecks in your DAX queries. This is a short introduction to this new version.  Watch now

video –

Optimizing & Analyzing DAX Query Plans

DAX is super-fast, you can use it to query billions of rows in less than one second. End of marketing, now let’s go back to the real world. If your query is not performing as advertised, it is time to…  Watch now