Understanding Performance Analyzer metrics in DAX Studio
Вставка
- Опубліковано 31 лип 2024
- Performance Analyzer metrics imported in DAX Studio provide many details not available in Power BI Desktop. Learn the meaning of each number and how to use them to find report bottlenecks.
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
DAX Studio: daxstudio.org/ - Наука та технологія
Finished watching
Awesome
Great video ! One question regarding the server timings for DAX queries. Is it possible to have an important difference between the performance analyser timings in Power Bi and the same query in Dax Studio? (If the data is coming from Analysis Services in live connection)
Good question! The measure made by Performance Analyzer in Power BI is client-side. The time measured for the DAX query execution includes the communication between client and server. The Server Timings pane in DAX Studio measures the execution time server-side only. However, if you look at Duration column in the Output window of DAX Studio, you should see the execution time measured client-side of the entire query. The difference between Duration and Server Timings execution is an estimate of the cost of the roundtrip client-server, including the time required to transfer the result (which could be important for large results).
Hi Marco,
we are using Power BI embedded with a tabular model on SSAS on-prem
So my reports are in the Power BI service and cannot be downloaded in PIBX format. So I cannot use / export performance analyzer data.
Any idea on how to get the metrics in this scenario ?
You should use VertiPaq Analyzer integrated in DAX Studio connecting to Power BI Embedded through the XMLA endpoint.
Nice Informative video. Do you also have a write up somewhere which compares what to use when - example we have Query diagnostics which can also be used for finding slow backend query. So what basically is different in the details we get out of the 2 places - Query Diagnostics and Performance Analyser. Thanks you!
The Optimizing DAX video course on www.sqlbi.com/training is dedicated to that topic. The next edition released in 2023 will also include Performance Analyzer, the current version is older but getting access now you will get the upgrade automatically.