Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Querry preparation failed

Hi all,

I am learning DAX and I have got a problem with Querry typed below:

EVALUATE
SUMMARIZECOLUMNS(
'Pick DC'[PDC Country],
'Pick DC'[PDC Number],
'Material'[MAT Business ID],
Customer[CS Customer Number],
Customer[CS Customer Description],
Material[MAT WRIN0],
Material[MAT Description],
Picking[Sales Order Key],
'Pick Date'[PD Date],
KEEPFILTERS( TREATAS( {"MCD","VAP","VGS","KFC"}, Material[MAT Business ID] )),
Filter('Pick Date','Pick Date'[PD Date]>=Today()),
Filter('Picking','Picking'[PCK Pick Order Status]=321),
Filter(VALUES(Material[MAT Business ID]),PATHCONTAINS(@MaterialMATBusinessID,Material[MAT Business ID])),
"Picked Planned Quantity",[Sales Order To Be Picked Quantity]
)

I am getting an error: Querry preparation failed

Do you know why this is happening? I am working on Power BI Report Builder

Thank you for help 🙂 

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , Syntax looks correct , the way to check is, Run this on Dax studio


    Start with one or two items and keep on adding after every successful, that should give you error

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

    As checked the formula which you provided, it seems OK. I found a thread which has the similar problem as yours, please check if its solution can help you resolve the problem.

    DAX Query fails to prepare

    I copy pasted everything (queries + tablix) in a new blank report and that works. Maybe I switched a setting somewhere or the file was corrupted. I have no idea.

    Anyway, now that works.

    Best Regards