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
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.
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
appreciate your explanation
Clear and comprehensive as usual. Bravo!
Great ! Short and to the point. Thank you !
Good presentation, thank you
Great tool, You explain it perfectly
Appreciate the way you explained it
excellent explanation sir
Very well explained - Thank you very much
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
Thanks for the video!
Great Explanation. Thank you.
Thank you, Sir.
Great Explanation.
Very Good Man Thank you
well explained, helps me !!
Please make video on difference between Formula engine and Storage engine.
Thank you !
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?
Sir how we perform load testing on Power BI?
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!
Thank you for the video... 👍