Failed to execute the DAX query in Power Automate

I'm currently trying to execute a query against a dataset using this connector. I keept getting a bad request error.

This is my DAX query 

EVALUATE
FILTER(
SUMMARIZECOLUMNS(
    Query[REPORTNAME],
    Query[REPORTID],
    Query[WORKSPACEID],
    Query[DATASETID],
    "Days Since Last Activity", [Days Since Last Activity],
    "Last Viewed DT", [Last Viewed DT]
)
,[Days Since Last Activity] >= 180
)
ORDER BY 
    Query[REPORTNAME] ASC,
    Query[REPORTID] ASC,
    Query[WORKSPACEID] ASC,
    Query[DATASETID] ASC