Forum Discussion
Not all rows in Power automate output
Hi All, I''m only getting 26K rows instead of the 60K rows what''s in the table from my power bi, what am i doing wrong in the query? // DAX Query DEFINE VAR __DS0FilterTable = TREATAS({"I...
lbendlin
Super User
Super UserEVALUATE SUMMARIZECOLUMNS(
'TASK'[search_code],
'TASK'[status_name],
'TASK'[till_date],
'AC'[Contractgebied],
'AC'[Aannemer],
'TASK'[type],
'TASK'[created],
'TASK'[comments],
'RFA'[RFA status],
'TASK'[(Plannedverleden)],
'AC'[BAGgebouwtype],
'TASK'[HOLDCODE],
'TASK'[OrderType],
'TASK'[id],
'AC'[Opleverstatus],
'TASK'[prev_pop],
'AC'[PandID all],
'AC'[Doc Status],
'TASK'[Aantal x Hold],
'AC'[DP nummer (ODF-TM)],
'AC'[Street],
'AC'[House nr.],
'AC'[Extension],
'AC'[Room],
'AC'[City],
'AC'[RNA totaal],
'AC'[HASdatumsAll],
'PLM'[MSA],
'TASK'[Taaktype],
TREATAS({"INSTALL"}, 'TASK'[type]),
TREATAS({"T-Mobile","Fiber Operator"}, 'TASK'[recipient_name]),
TREATAS({"CONFIRMED","ON_HOLD","PREPARED","TO_BE_CANCELLED","WIP","RECEIVED"},'TASK'[status_name]
),
"CountRowsTASK", CALCULATE(COUNTROWS('TASK'))
)