Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Anonymous
Not applicable

How to drill down in performance analyzer?

I need to dig deeper in Performance analizer, because the exact same visual sometime it takes:

ovonel_0-1675178492441.png

 

and sometimes it just takes:

ovonel_2-1675178552001.png

 

How is it possible?

 

 

Both are executing the exact same DAX query:

 

 

 

// DAX Query

DEFINE

  VAR __DS0FilterTable =

    TREATAS({"Engagement Manager"}, 'Engagement Role'[Engagement Role])

 

  VAR __DS0FilterTable2 =

    TREATAS({"Tim J"}, 'Employee Current'[Name])

 

  VAR __DS0FilterTable3 =

    TREATAS({"FY23 - 07 - Dec"}, 'Date'[FY and Month])

 

  VAR __DS0FilterTable4 =

    FILTER(

      KEEPFILTERS(VALUES('Date'[Month Offset])),

      AND('Date'[Month Offset] < 0, 'Date'[Month Offset] > -2)

    )

 

  VAR __DS0Core =

    SUMMARIZECOLUMNS(

      'Key Figures Header'[Header],

      'Key Figures Header'[SortOrder],

      __DS0FilterTable,

      __DS0FilterTable2,

      __DS0FilterTable3,

      __DS0FilterTable4,

      "Key_Figures_LTM", 'Calculations'[Key Figures LTM],

      "Key_Figures_LTM_LY", 'Calculations'[Key Figures LTM LY],

      "Key_Figures_Dev__LY", 'Calculations'[Key Figures Dev. LY],

      "Key_Figures_Growth__", 'Calculations'[Key Figures Growth %]

    )

 

  VAR __DS0PrimaryWindowed =

    TOPN(501, __DS0Core, 'Key Figures Header'[SortOrder], 1, 'Key Figures Header'[Header], 1)

 

EVALUATE

  __DS0PrimaryWindowed

 

ORDER BY

  'Key Figures Header'[SortOrder], 'Key Figures Header'[Header]

 

 

 

The only difference is that in the execution that takes LONGER , I am removing myself from the 'Read all' role, and I guess I can't jump over the RLS stuff... but i dont get why no RLS dax code is shown, if that is what is making it so slow....

0 REPLIES 0

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.