Hi there
Please can someone let me know why I am getting an error with this step in my flow:
{ "error": { "code": "DatasetExecuteQueriesError", "pbi.error": { "code": "DatasetExecuteQueriesError", "parameters": {}, "details": [ { "code": "DetailsMessage", "detail": { "type": 1, "value": "Query (28, 3) The syntax for ')' is incorrect. (// DAX Query\nDEFINE\nVAR _TodaysDate = TODAY()\n\n\tVAR __DS0FilterTable = \n\t\tTREATAS({\"andy.test@abc.com\"}, 'SDT Clarity Tasks'[Assignee])\n\n\tVAR __DS0FilterTable2 = \n\t\tFILTER(\n\t\t\tKEEPFILTERS(VALUES('SDT Clarity Tasks'[Status])),\n\t\t\tAND(\n\t\t\t\tNOT(SEARCH(\"Closed\", 'SDT Clarity Tasks'[Status], 1, 0) >= 1),\n\t\t\t\tNOT(SEARCH(\"Completed\", 'SDT Clarity Tasks'[Status], 1, 0) >= 1)\n\t\t\t)\n\t\t)\n\n\tVAR __DS0FilterTable3 = \n\t\tFILTER(\n\t\t\tKEEPFILTERS(VALUES('SDT Clarity Tasks'[Phase])),\n\t\t\tNOT(SEARCH(\"Delivered\", 'SDT Clarity Tasks'[Phase], 1, 0) >= 1)\n\t\t)\n\n\tVAR __DS0FilterTable4 = \n\t\tFILTER(\n\t\t\tKEEPFILTERS(VALUES('SDT Clarity Tasks'[ETD])),\n\t\t\t\t\t\t'SDT Clarity Tasks'[ETD] = _TodaysDate\n\t\t\t)\n\t\t)\n\n\tVAR __DS0Core = \n\t\tSELECTCOLUMNS(\n\t\t\tKEEPFILTERS(\n\t\t\t\tFILTER(\n\t\t\t\t\tKEEPFILTERS(\n\t\t\t\t\t\tSUMMARIZECOLUMNS(\n\t\t\t\t\t\t\t'SDT Clarity Tasks'[Assignee],\n\t\t\t\t\t\t\t'SDT Clarity Tasks'[ID],\n\t\t\t\t\t\t\t'SDT Clarity Tasks'[Customer],\n\t\t\t\t\t\t\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Year],\n\t\t\t\t\t\t\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Month],\n\t\t\t\t\t\t\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[MonthNo],\n\t\t\t\t\t\t\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Day],\n\t\t\t\t\t\t\t__DS0FilterTable,\n\t\t\t\t\t\t\t__DS0FilterTable2,\n\t\t\t\t\t\t\t__DS0FilterTable3,\n\t\t\t\t\t\t\t__DS0FilterTable4,\n\t\t\t\t\t\t\t\"CountRowsSDT_Clarity_Tasks\", COUNTROWS('SDT Clarity Tasks')\n\t\t\t\t\t\t)\n\t\t\t\t\t),\n\t\t\t\t\tOR(\n\t\t\t\t\t\tOR(\n\t\t\t\t\t\t\tOR(\n\t\t\t\t\t\t\t\tOR(\n\t\t\t\t\t\t\t\t\tOR(\n\t\t\t\t\t\t\t\t\t\tOR(\n\t\t\t\t\t\t\t\t\t\t\tNOT(ISBLANK('SDT Clarity Tasks'[Assignee])),\n\t\t\t\t\t\t\t\t\t\t\tNOT(ISBLANK('SDT Clarity Tasks'[ID]))\n\t\t\t\t\t\t\t\t\t\t),\n\t\t\t\t\t\t\t\t\t\tNOT(ISBLANK('SDT Clarity Tasks'[Customer]))\n\t\t\t\t\t\t\t\t\t),\n\t\t\t\t\t\t\t\t\tNOT(ISBLANK('LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Year]))\n\t\t\t\t\t\t\t\t),\n\t\t\t\t\t\t\t\tNOT(ISBLANK('LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Month]))\n\t\t\t\t\t\t\t),\n\t\t\t\t\t\t\tNOT(ISBLANK('LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[MonthNo]))\n\t\t\t\t\t\t),\n\t\t\t\t\t\tNOT(ISBLANK('LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Day]))\n\t\t\t\t\t)\n\t\t\t\t)\n\t\t\t),\n\t\t\t\"'SDT Clarity Tasks'[Assignee]\", 'SDT Clarity Tasks'[Assignee],\n\t\t\t\"'SDT Clarity Tasks'[ID]\", 'SDT Clarity Tasks'[ID],\n\t\t\t\"'SDT Clarity Tasks'[Customer]\", 'SDT Clarity Tasks'[Customer],\n\t\t\t\"'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Year]\", 'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Year],\n\t\t\t\"'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Month]\", 'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Month],\n\t\t\t\"'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[MonthNo]\", 'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[MonthNo],\n\t\t\t\"'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Day]\", 'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Day]\n\t\t)\n\n\tVAR __DS0PrimaryWindowed = \n\t\tTOPN(\n\t\t\t501,\n\t\t\t__DS0Core,\n\t\t\t'SDT Clarity Tasks'[Assignee],\n\t\t\t1,\n\t\t\t'SDT Clarity Tasks'[ID],\n\t\t\t1,\n\t\t\t'SDT Clarity Tasks'[Customer],\n\t\t\t1,\n\t\t\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Year],\n\t\t\t1,\n\t\t\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[MonthNo],\n\t\t\t1,\n\t\t\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Month],\n\t\t\t1,\n\t\t\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Day],\n\t\t\t1\n\t\t)\n\nEVALUATE\n\t__DS0PrimaryWindowed\n\nORDER BY\n\t'SDT Clarity Tasks'[Assignee],\n\t'SDT Clarity Tasks'[ID],\n\t'SDT Clarity Tasks'[Customer],\n\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Year],\n\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[MonthNo],\n\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Month],\n\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Day]\n)." } }, { "code": "AnalysisServicesErrorCode", "detail": { "type": 1, "value": "3238920194" } } ] } } }
The query is this:
{ "groupid": "58366a46-0e11-4996-8a91-3cc1f5b1eaf5", "datasetid": "4f25f6ea-c53f-4f11-948d-51ebd39da8ff", "specification/query": "// DAX Query\nDEFINE\nVAR _TodaysDate = TODAY()\n\n\tVAR __DS0FilterTable = \n\t\tTREATAS({\"andy.test@abc.com\"}, 'SDT Clarity Tasks'[Assignee])\n\n\tVAR __DS0FilterTable2 = \n\t\tFILTER(\n\t\t\tKEEPFILTERS(VALUES('SDT Clarity Tasks'[Status])),\n\t\t\tAND(\n\t\t\t\tNOT(SEARCH(\"Closed\", 'SDT Clarity Tasks'[Status], 1, 0) >= 1),\n\t\t\t\tNOT(SEARCH(\"Completed\", 'SDT Clarity Tasks'[Status], 1, 0) >= 1)\n\t\t\t)\n\t\t)\n\n\tVAR __DS0FilterTable3 = \n\t\tFILTER(\n\t\t\tKEEPFILTERS(VALUES('SDT Clarity Tasks'[Phase])),\n\t\t\tNOT(SEARCH(\"Delivered\", 'SDT Clarity Tasks'[Phase], 1, 0) >= 1)\n\t\t)\n\n\tVAR __DS0FilterTable4 = \n\t\tFILTER(\n\t\t\tKEEPFILTERS(VALUES('SDT Clarity Tasks'[ETD])),\n\t\t\t\t\t\t'SDT Clarity Tasks'[ETD] = _TodaysDate\n\t\t\t)\n\t\t)\n\n\tVAR __DS0Core = \n\t\tSELECTCOLUMNS(\n\t\t\tKEEPFILTERS(\n\t\t\t\tFILTER(\n\t\t\t\t\tKEEPFILTERS(\n\t\t\t\t\t\tSUMMARIZECOLUMNS(\n\t\t\t\t\t\t\t'SDT Clarity Tasks'[Assignee],\n\t\t\t\t\t\t\t'SDT Clarity Tasks'[ID],\n\t\t\t\t\t\t\t'SDT Clarity Tasks'[Customer],\n\t\t\t\t\t\t\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Year],\n\t\t\t\t\t\t\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Month],\n\t\t\t\t\t\t\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[MonthNo],\n\t\t\t\t\t\t\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Day],\n\t\t\t\t\t\t\t__DS0FilterTable,\n\t\t\t\t\t\t\t__DS0FilterTable2,\n\t\t\t\t\t\t\t__DS0FilterTable3,\n\t\t\t\t\t\t\t__DS0FilterTable4,\n\t\t\t\t\t\t\t\"CountRowsSDT_Clarity_Tasks\", COUNTROWS('SDT Clarity Tasks')\n\t\t\t\t\t\t)\n\t\t\t\t\t),\n\t\t\t\t\tOR(\n\t\t\t\t\t\tOR(\n\t\t\t\t\t\t\tOR(\n\t\t\t\t\t\t\t\tOR(\n\t\t\t\t\t\t\t\t\tOR(\n\t\t\t\t\t\t\t\t\t\tOR(\n\t\t\t\t\t\t\t\t\t\t\tNOT(ISBLANK('SDT Clarity Tasks'[Assignee])),\n\t\t\t\t\t\t\t\t\t\t\tNOT(ISBLANK('SDT Clarity Tasks'[ID]))\n\t\t\t\t\t\t\t\t\t\t),\n\t\t\t\t\t\t\t\t\t\tNOT(ISBLANK('SDT Clarity Tasks'[Customer]))\n\t\t\t\t\t\t\t\t\t),\n\t\t\t\t\t\t\t\t\tNOT(ISBLANK('LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Year]))\n\t\t\t\t\t\t\t\t),\n\t\t\t\t\t\t\t\tNOT(ISBLANK('LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Month]))\n\t\t\t\t\t\t\t),\n\t\t\t\t\t\t\tNOT(ISBLANK('LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[MonthNo]))\n\t\t\t\t\t\t),\n\t\t\t\t\t\tNOT(ISBLANK('LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Day]))\n\t\t\t\t\t)\n\t\t\t\t)\n\t\t\t),\n\t\t\t\"'SDT Clarity Tasks'[Assignee]\", 'SDT Clarity Tasks'[Assignee],\n\t\t\t\"'SDT Clarity Tasks'[ID]\", 'SDT Clarity Tasks'[ID],\n\t\t\t\"'SDT Clarity Tasks'[Customer]\", 'SDT Clarity Tasks'[Customer],\n\t\t\t\"'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Year]\", 'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Year],\n\t\t\t\"'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Month]\", 'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Month],\n\t\t\t\"'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[MonthNo]\", 'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[MonthNo],\n\t\t\t\"'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Day]\", 'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Day]\n\t\t)\n\n\tVAR __DS0PrimaryWindowed = \n\t\tTOPN(\n\t\t\t501,\n\t\t\t__DS0Core,\n\t\t\t'SDT Clarity Tasks'[Assignee],\n\t\t\t1,\n\t\t\t'SDT Clarity Tasks'[ID],\n\t\t\t1,\n\t\t\t'SDT Clarity Tasks'[Customer],\n\t\t\t1,\n\t\t\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Year],\n\t\t\t1,\n\t\t\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[MonthNo],\n\t\t\t1,\n\t\t\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Month],\n\t\t\t1,\n\t\t\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Day],\n\t\t\t1\n\t\t)\n\nEVALUATE\n\t__DS0PrimaryWindowed\n\nORDER BY\n\t'SDT Clarity Tasks'[Assignee],\n\t'SDT Clarity Tasks'[ID],\n\t'SDT Clarity Tasks'[Customer],\n\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Year],\n\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[MonthNo],\n\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Month],\n\t'LocalDateTable_85d7c4ad-513b-40f5-83df-1aec3770b53d'[Day]\n", "specification/serializerSettings/includeNulls": false }
Many thanks !
VictorIvanidze
4
BK-01100935-0
4
frontrowna
2