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