Power BI has added the ability to analyse report performance on Power BI Desktop. This means if your reports are running slow , you can now use Performance analyzer on Power BI Desktop to identify the culprit and find out the reason for the impact.

From View, click Performance Analyzer to enable the option

Click on Start recording to begin recording the performance

When you interact with your report, like refreshing the visuals, filtering the reports etc. Performance Analyzer logs all the activities and if you have long running report, you can identify which visual is the culprit by looking at the time it took to run.

You can further analyse and optimize the result by copying the DAX query to a notepad or export the logs and save as a .jason file . Click on stop to stop recording.

// DAX Query
DEFINE
VAR __DS0FilterTable =
TREATAS(
{“Black”, “Blue”, “Grey”, “Multi”,”Red”,”Silver”, “Silver/Black”,
“White”,
“Yellow”},
‘Production Product'[Color]
)

VAR __DS0FilterTable2 =
TREATAS({“R”,
“S”,
“T”,
“M”}, ‘Production Product'[ProductLine])

EVALUATE
SAMPLE(
502,
SUMMARIZECOLUMNS(
‘HumanResources EmployeePayHistory'[Month],
__DS0FilterTable,
__DS0FilterTable2,
“SumRate”, CALCULATE(SUM(‘HumanResources EmployeePayHistory'[Rate]))
),
[SumRate],
0,
‘HumanResources EmployeePayHistory'[Month],
1
)

ORDER BY
[SumRate] DESC, ‘HumanResources EmployeePayHistory'[Month]