Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
LukeWalker
Advocate IV
Advocate IV

EVALUATE SELECTCOLUMNS() in background slows down report

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

6 REPLIES 6
leokarpa
Frequent Visitor

same problem here.. anyone solved? 

Please help

Anonymous
Not applicable

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

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

RMcClen
Regular Visitor

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

v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.