Introducing Performance Analyzer in Power BI Desktop
Vložit
- čas přidán 24. 06. 2020
- Performance Analyzer is the first diagnostic tool to find the slower parts of a report. Find the slowest DAX query before starting a deeper investigation using DAX Studio.
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
DAX Studio: daxstudio.org/ - Věda a technologie
Good presentation, thank you
Clear and comprehensive as usual. Bravo!
Great ! Short and to the point. Thank you !
Great tool, You explain it perfectly
Appreciate the way you explained it
Very well explained - Thank you very much
Great Explanation. Thank you.
Great Explanation.
well explained, helps me !!
Thanks for the video!
excellent explanation sir
Thank you for the video... 👍
Thank you, Sir.
Very Good Man Thank you
Please make video on difference between Formula engine and Storage engine.
Thank you !
Thanks for the video. When I import the json onto DAX Studio and I run the Query of a visual on DAX Studio, the ms that I get for that query/visual in Server Timings does not match the Query Ms or Total Ms column from the json. Why? Should not these match? Thanks.
The numbers are more consistent in the exported file as they don't include the "Other". There is an explanation in the documentation (get the .DOCX file): github.com/microsoft/powerbi-desktop-samples/tree/main/Performance%20Analyzer
I am trying to build a multi value parameter paginated report in Power BI.
I tried this -
EVALUATE
SUMMARIZECOLUMNS (
'Product Category'[Product Category Name],
FILTER (
VALUES ( 'Geography'[Country Region Name] ),
PATHCONTAINS ( @CountryRegionName, 'Geography'[Country Region Name] )
),
FILTER (
VALUES ('Date'[Fiscal Year] ),
PATHCONTAINS ( @FiscalYear, 'Date'[Fiscal Year] )
),
"Internet Total Sales", [Internet Total Sales],
"Internet Total Margin", [Internet Total Margin]
)
My scenario is little different. I want to filter either on Geography or by date. Meaning - if user enters Geography filter by Geography. If user enters date filter by date. If both are entered filter by all the records of Geography and all the records of date. Outer join. Please help.
I tried all the blogs.. No luck yet
Please post the question in comments of a related article, such as www.sqlbi.com/articles/introducing-summarizecolumns/
Thanks!
Sir how we perform load testing on Power BI?
If I refresh all the visuals, time shows in the performance analyzer, is it the total time taken by the report?
Not really - every visual shows the total time to render, but the Other time is a waiting time for other visuals. You also have parallelism to take into account. Future videos will show how to export performance data to DAX Studio for a better evaluation.
@@marcorusso7472 Hey Marco thanks for you clear explanation on this topic
,Pls where can i get the next video for better evaluation?