EVALUATE SELECTCOLUMNS() in background slows down report

[LukeWalker]

I've begun using DaxStudio, and I noticed in a larger report of mine that any change is followed by hundreds of iterations of the following query for what seems to be every column:

EVALUATE SELECTCOLUMNS(FILTER(VALUES(table[column]),LEN(table[column])<=100),"valueColumn", table[column])

Most of these complete in 10-20 milliseconds. This occurs even on a blank page with all report-level filters cleared. However, for a larger table in the model (~1M rows) that requires a unique identifier text column, the query takes almost a minute. I am unsure what is causing this behaviour and whether there is anything that I can do to mitigate it. Unfortunately, I am unable to share the model or table. Does anyone have ideas what I could check or try to fix this?

Regards,

Luke

[leokarpa]

same problem here.. anyone solved? 

Please help

[Anonymous]

Did you ever figure this out? I am experiencing this same thing.

[DSiffredi]

Any news on this ? I'm experiencing the same issue. 

[RMcClen]

Did you ever figure this out? I'm experiencing the same thing after downloading DAX Studio

[v-yuezhe-msft]

@LukeWalker,

What is your data source and what operations do you take in Query Editor of Power BI Desktop? How do you capture the above query?

Regards,
Lydia

[LukeWalker]

My data source is SQL server. I have ~70 tables, some with quite a number of steps. The above query was captured via Dax Studio.