Analyzing a slow report query in DAX Studio

753Likes

48,198Views

2020Jul 16

Investigate a slow query in a Power BI report using DAX Studio, looking at the query plan and the server timings. How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt DAX Studio: https://daxstudio.org/ Optimizing DAX Workshop: https://www.sqlbi.com/p/optimizing-da...

Query Plan and the Execution Timings

3:35

Query Plan and Server Timings

3:38

Test the Behavior of the Measure

8:14

Server Timings

9:52

Transcript

Follow along using the transcript.

SQLBI

120K subscribers

Debugging a slow Power BI report with Phil Seamark

Guy in a Cube

•

74K views 5 years ago

Analyzing a slow report query in DAX Studio

Key moments View all

Query Plan and the Execution Timings

Query Plan and the Execution Timings

Query Plan and the Execution Timings

Query Plan and Server Timings

Query Plan and Server Timings

Query Plan and Server Timings

Test the Behavior of the Measure

Test the Behavior of the Measure

Test the Behavior of the Measure

Server Timings

Server Timings

Server Timings

SQLBI

Analyzing a slow report query in DAX Studio

Comments 38

Key moments

Query Plan and the Execution Timings

Query Plan and the Execution Timings

Query Plan and the Execution Timings

Query Plan and Server Timings

Query Plan and Server Timings

Query Plan and Server Timings

Test the Behavior of the Measure

Test the Behavior of the Measure

Test the Behavior of the Measure

Server Timings

Server Timings

Server Timings

Description

Key moments View all

Query Plan and the Execution Timings

Query Plan and the Execution Timings

Query Plan and the Execution Timings

Query Plan and Server Timings

Query Plan and Server Timings

Query Plan and Server Timings

Test the Behavior of the Measure

Test the Behavior of the Measure

Test the Behavior of the Measure

Server Timings

Server Timings

Server Timings

SQLBI

Transcript

Debugging a slow Power BI report with Phil Seamark

Key moments

Key moments