ALL NEW! error: specified query is too complex to be evaluated as a single statement

[WizardWalksBy]

Welp, everything ran fine before... where do I start with this? 

Feedback Type:
Frown (Error)

Timestamp:
2016-12-07T18:00:46.0074057Z

Local Time:
2016-12-07T12:00:46.0074057-06:00

Product Version:
2.41.4581.361 (PBIDesktop) (x64)

Release:
November, 2016

IE Version:
11.0.9600.18524

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)

CLR Version:
4.6.1 or later [Release Number = 394271]

Workbook Package Info:
1* - en-US, fastCombine: Enabled.

Peak Working Set:
6.4 GB

Private Memory:
1.62 GB

Peak Virtual Memory:
9.92 GB

Error Message:
The specified query is too complex to be evaluated as a single statement.

[v-qiuyu-msft]

Hi @WizardWalksBy,

Would you please clarify which action you take in desktop then the error throws out? Please share detail information with us, so that we can test it in our environment.

Best Regards,

Qiuyun Yu

[tringuyenminh92]

I got same situation when using DirectQuery with 900.000 rows and calculation measure. It maybe refer too much another measures or using not optimize function in your case. Could you please show us your formula of measure/calculated column with picture of table structure? After observation your calculation, we could try to refine it for better perfomance.