Forum Discussion

frithjof_v's avatar
frithjof_v
Community Champion
2 years ago

Using variable vs. referencing another query

Hi,   I am wondering if there is some obvious conceptual difference (which may impact performance) between referencing a variable (i.e. referencing another step in the same query), or referencing t...
Tips and Tricks
tharunkumarRTK's avatar
tharunkumarRTK
Super User
2 years ago

frithjof_v 
In terms of performance, I think referencing the variable step in the same query would be a better option. Because, each individual query evaulates independently. You can find more information in chirs webb's blog 
https://blog.crossjoin.co.uk/2019/10/13/why-does-power-bi-query-my-data-source-more-than-once/



Need Power BI consultation, hire me on UpWork .


If the post helps please give a thumbs up



If it solves your issue, please accept it as the solution to help the other members find it more quickly.




Tharun



  • frithjof_v's avatar
    frithjof_v
    Community Champion
    2 years ago

    Thanks tharunkumarRTK,

     

    I was thinking something similar.

     

    However I tried refreshing the two tables separately in Power BI Desktop, and by looking in SQL Server Profiler it seems the Command End events for both tables had very similar CPUTime and Duration. 

     

     

    (I'm not sure if the Command Begin and Command End are the most relevant events to track. If anyone have suggestion about which events I should track, please let me know.)