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 Produc...
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.