Forum Discussion

MIkkelHyldig's avatar
MIkkelHyldig
Helper II
4 years ago
Solved

Remove TOPN from query

Hi guys, For Power Automate I need to run a query for a table and therefore I copy my query from performance analyzer in Power BI from the table I need.  However, instead of returning the entir...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    MIkkelHyldig , Try like

     

    // DAX Query
    DEFINE
    VAR __DS0Core =
    SUMMARIZE(
    'Activity',
    'Activity'[Activity],
    'Activity'[CapacityName],
    'Activity'[LastRefreshTime],
    'Activity'[Report_BK],
    'Activity'[User_BK],
    'Activity'[Date_Creation_BK],
    'Activity'[Dataset_BK],
    'Activity'[Group_BK],
    'Activity'[Time_Creation_BK]
    )


    EVALUATE
    __DS0Core

    ORDER BY
    'Activity'[Activity],
    'Activity'[CapacityName],
    'Activity'[LastRefreshTime],
    'Activity'[Report_BK],
    'Activity'[User_BK],
    'Activity'[Date_Creation_BK],
    'Activity'[Dataset_BK],
    'Activity'[Group_BK],
    'Activity'[Time_Creation_BK]

amitchandak's avatar
amitchandak
Super User
4 years ago

MIkkelHyldig , Try like

 

// DAX Query
DEFINE
VAR __DS0Core =
SUMMARIZE(
'Activity',
'Activity'[Activity],
'Activity'[CapacityName],
'Activity'[LastRefreshTime],
'Activity'[Report_BK],
'Activity'[User_BK],
'Activity'[Date_Creation_BK],
'Activity'[Dataset_BK],
'Activity'[Group_BK],
'Activity'[Time_Creation_BK]
)


EVALUATE
__DS0Core

ORDER BY
'Activity'[Activity],
'Activity'[CapacityName],
'Activity'[LastRefreshTime],
'Activity'[Report_BK],
'Activity'[User_BK],
'Activity'[Date_Creation_BK],
'Activity'[Dataset_BK],
'Activity'[Group_BK],
'Activity'[Time_Creation_BK]

MIkkelHyldig's avatar
MIkkelHyldig
Helper II
4 years ago

Thanks amitchandak ,

It worked. I tried to remove the variable "TopN" and the ORDER BY but got an error. Is the solution to keep the ORDER BY function?