Forum Discussion

WizardWalksBy's avatar
WizardWalksBy
Frequent Visitor
9 years ago

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

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.

 

2 Replies

  • tringuyenminh92's avatar
    tringuyenminh92
    Icon for Memorable Member rankMemorable Member
    9 years ago

    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.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    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