topic Re: Querry preparation failed in DAX Commands and Tips

Querry preparation failed

Anonymous — Thu, 12 Jan 2023 22:49:50 GMT

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 🙂

Re: Querry preparation failed

amitchandak — Fri, 13 Jan 2023 02:39:44 GMT

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

Re: Querry preparation failed

Anonymous — Fri, 13 Jan 2023 02:54:46 GMT

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