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 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.