topic Re: Performance identifying Measure in DAX Commands and Tips

Performance identifying Measure

VenuBollineni — Thu, 12 Dec 2024 03:30:21 GMT

I have a model that contains 200 measures. It is a centralized model for finance, and multiple reports are developed from it. I need to know which measure is causing an issue. Is it possible to identify the problematic measure using DAX Studio from the complete model, not report-wise?

Re: Performance identifying Measure

Poojara_D12 — Thu, 12 Dec 2024 04:47:38 GMT

Hi VenuBollineni

To identify the problematic measure in DAX Studio:

Connect to Your Model: Open DAX Studio and connect to your centralized model.
Enable Tracing: Turn on Server Timings and Query Plan.
Run Queries: Interact with your report or execute queries to trigger measure evaluations.
Analyze Performance: Check Server Timings for slow or long-duration queries and identify the measure causing issues.
Test Individual Measures: Write test queries in DAX Studio to pinpoint the problematic measure.
Optimize: Simplify DAX logic or reduce dependencies for the identified measure.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS

Re: Performance identifying Measure

v-ssriganesh — Thu, 12 Dec 2024 09:32:27 GMT

Hi
Thanks for posting your query in community forum.

To identify the problematic measure in your centralized model, you can use Power BI Desktop's Performance Analyzer by following these steps:

1.In Power BI Desktop, go to the View ribbon and select Performance Analyzer to display the Performance Analyzer pane.

2. Click the Start recording button. What you do in the report is visible and recorded in the Performance Analyzer pane.
3. Now, go ahead, for instance, and touch slicers or click the visuals. This will introduce queries
4. Through the Performance Analyzer, all the duration required to refresh or update all the visuals should be presented. Identify which measure or which visual is holding up longer. You could even take the performance log and send it elsewhere for further analysis.

Below is related link for performance analyzer
Use Performance Analyzer to examine report element performance in Power BI Desktop

If this help then please Accept it as solution & don't forget to drop a "Kudos", so other members can able to find this more rapidly.
Hope this will work.
Thanks.

Re: Performance identifying Measure

mark_endicott — Thu, 12 Dec 2024 12:55:19 GMT

VenuBollineni - How do you know if a DAX measure is performing poorly if it's not used in a report??

DAX measures will not run a query against your model unless they are used in a visual.

Once you have identified the measure that is causing a report or visual to run slowly you can use DAX Studio against your server held model through the XMLA Endpoint.

However, you can only use this if you have a Premium Capacity or PPU: https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools

If you do not have either you can still use DAX Studio, but you will need to use it againts your model from the PBI Desktop file - it will need to have enough data in, which will mean unleashing some of your data limiting parameters if you do this.

Re: Performance identifying Measure

v-ssriganesh — Wed, 18 Dec 2024 06:15:37 GMT

Hi VenuBollineni

May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Re: Performance identifying Measure

v-ssriganesh — Tue, 24 Dec 2024 07:06:23 GMT

Hi VenuBollineni

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

Re: Performance identifying Measure

v-ssriganesh — Fri, 27 Dec 2024 06:49:15 GMT

Hi VenuBollineni
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.