topic Re: Identify DAX Measures consuming too long to process in Report Server

Identify DAX Measures consuming too long to process

MAli_Ch — Fri, 25 Oct 2024 16:01:08 GMT

I have a tabular model on Visual Studio where data size is normal. It use to take 35-40 min to refresh 1 month back but someone added/modified few DAX Measures. Since then it is taking too long too refresh data. I want to indentify measures which are causing this issue. I have used these measures in Power BI reports too. How can I findout these measures so my model can be efficient and start refreshing normally.

Re: Identify DAX Measures consuming too long to process

lbendlin — Fri, 25 Oct 2024 20:37:21 GMT

Connect DAX Studio to your tabular model and check the Query plan and Server Timings for these measures.

Re: Identify DAX Measures consuming too long to process

MAli_Ch — Mon, 28 Oct 2024 08:58:21 GMT

Hi lbendlin, thanks for responding. I want to know one more thing here that I have few calculated columns inside my tabular model I want to evaluate those too. How can I perform testing on it?

Re: Identify DAX Measures consuming too long to process

MAli_Ch — Mon, 28 Oct 2024 10:06:58 GMT

Also I need to know that can my partitions be slow due to data fetching is taking place from a view which has a quite complex query and mulitple joins?

Re: Identify DAX Measures consuming too long to process

lbendlin — Mon, 28 Oct 2024 11:30:29 GMT

Same answer - use DAX Studio