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]

AlLangstaff's avatar
AlLangstaff
Frequent Visitor
3 years ago

Old, but in case anyone is here looking for answers. You can just drop these queries into PowerBI Report builder to quickly and easily write the DAX for a Paginated Report. No row limit then.

MarkPalmberg's avatar
MarkPalmberg
Kudo Commander
1 year ago

AlLangstaff what does this mean?

AlLangstaff wrote:

Old, but in case anyone is here looking for answers. You can just drop these queries into PowerBI Report builder to quickly and easily write the DAX for a Paginated Report. No row limit then.

Drop from where?