Forum Discussion
Performance identifying Measure
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.
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.
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.