Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
10 months ago
Solved

view dax query behind visual

how to view dax query generated behind visual?, example , I want to know DAX query generated behind bar chart 

also, can i see the DAX query generated behind measures or calculated column and calculated table?

Need Help
  • GrowthNatives's avatar
    GrowthNatives
    10 months ago

    Hi powerbiexpert22 , 
    Unfortunately PowerBI can't directly show the DAX query for a visual in the UI, but you can capture it using DAX Studio.

    1. DAX Query behind visual 

    1. Connect DAX Studio to your Power BI Desktop file.

    2. Select the model → “All Queries.”

    3. Interact with the visual in Power BI.

    4. In DAX Studio: Server Timings → Start → Interact → Stop.

    5. DAX Studio shows the exact DAX query sent to VertiPaq.

    2. Measures

    • Measures are evaluated only in context; no standalone query exists.

    • You can:

      • View the measure formula in the editor.

      • Capture its DAX when used in a visual (via DAX Studio or Performance Analyzer).

    3. Calculated columns

    • Computed at refresh and stored in the model.

    • No runtime query exists; only the formula is visible.

    4. Calculated tables

    • Evaluated once at refresh and stored.

    • No dynamic query exists; only the table’s DAX formula is available.


      ⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
      💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
      🚀Let’s keep building smarter, data-driven solutions together! 🚀 [Explore More]

8 Replies

  • pankajnamekar25's avatar
    pankajnamekar25
    Super User
    10 months ago

    Hello powerbiexpert22 

    Use Performance Analyzer 

    Go to View tab → Enable Performance Analyzer.

    Click Start Recording.

    Interact with your visual (e.g., refresh or click the bar chart).

    In Performance Analyzer pane → find your visual → click Copy query.

    Paste it into DAX Studio or Notepad → this shows the exact DAX query Power BI generated.

     


    If my response helped you, please consider clicking
    Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.


    Thanks,


    Connect with me on:

    LinkedIn

     

  • GrowthNatives's avatar
    GrowthNatives
    Super User
    10 months ago

    Hi powerbiexpert22 , 
    Unfortunately PowerBI can't directly show the DAX query for a visual in the UI, but you can capture it using DAX Studio.

    1. DAX Query behind visual 

    1. Connect DAX Studio to your Power BI Desktop file.

    2. Select the model → “All Queries.”

    3. Interact with the visual in Power BI.

    4. In DAX Studio: Server Timings → Start → Interact → Stop.

    5. DAX Studio shows the exact DAX query sent to VertiPaq.

    2. Measures

    • Measures are evaluated only in context; no standalone query exists.

    • You can:

      • View the measure formula in the editor.

      • Capture its DAX when used in a visual (via DAX Studio or Performance Analyzer).

    3. Calculated columns

    • Computed at refresh and stored in the model.

    • No runtime query exists; only the formula is visible.

    4. Calculated tables

    • Evaluated once at refresh and stored.

    • No dynamic query exists; only the table’s DAX formula is available.


      ⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
      💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
      🚀Let’s keep building smarter, data-driven solutions together! 🚀 [Explore More]

  • GrowthNatives's avatar
    GrowthNatives
    Super User
    10 months ago

    powerbiexpert22 For further details ,you can check these

    1. Measures

    Measures are evaluated only in context; no standalone query exists.

    You can:

    View the measure formula in the editor.

    Capture its DAX when used in a visual (via DAX Studio or Performance Analyzer).

    2. Calculated columns

    Computed at refresh and stored in the model.

    No runtime query exists; only the formula is visible.

    3. Calculated tables

    Evaluated once at refresh and stored.

    No dynamic query exists; only the table’s DAX formula is available.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 months ago

    Hi powerbiexpert22 ,

    Thanks pankajnamekar25  and pankajnamekar25 for the clear explanations . As you mentioned, DAX queries behind visuals can be captured using Performance Analyzer or DAX Studio, while for measures, calculated columns, and calculated tables only the written formula is available (no separate runtime query).

    powerbiexpert22  did you get a chance to try this with your bar chart? If you still face any issues, feel free to share happy to help further.

    Thanks,
    Akhil.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 months ago

    Hi powerbiexpert22 ,

    Just checking in were you able to try out capturing the DAX queries using Performance Analyzer or DAX Studio with your bar chart? Let us know if you ran into any issues or if everything worked as expected.

    Thanks,
    Akhil.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 months ago

    Hi powerbiexpert22 ,

    Just wanted to check back were you able to capture the DAX queries from the bar chart using Performance Analyzer or DAX Studio? If you’ve already tested it, we’d love to hear what you found. And if you ran into any issues, we can help you troubleshoot further

    Thanks,
    Akhil.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 months ago

    Hi powerbiexpert22 ,

    I hope the response provided helped in resolving the issue. If you still have any questions, please let us know we are happy to address.

    Thanks,
    Akhil.