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