Forum Discussion

BugmanJ's avatar
BugmanJ
Helper V
2 years ago

Feeling the need for Speed! (Using DirectQuery Vs Summerize) and measures off these?

Good Morning,

Quick question, whats the best/preferred way to use DirectQuery? Do you use it direct into your visuals, or build Summary Tables off of it which you then use in your visuals?

In addition, measures based off which (direct/summary) offer faster value?

Thank you

Need Help

2 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    Hi BugmanJ 
    Direct Query Advanatge and use case:

    DirectQuery in Power BI offers the greatest benefits in the following scenarios:

    • The data changes frequently, and you need near real-time reporting.
    • You need to handle large data without having to pre-aggregate.
    • The underlying source defines and applies security rules.
    • Data sovereignty restrictions apply.
    • The source is a multidimensional source containing measures, such as SAP BW.

    Some general implications and limitations of using DirectQuery follow:

     

    If data changes, you must refresh to show the latest data.
    If data changes, there's no guarantee of consistency between visuals.
    You must refresh in Power BI Desktop to reflect schema changes.

    A limit of 1 million rows can return on any query
    ou can't change a model from import to DirectQuery mode.

     

    It is recommended to use when you have large dataset but slow down the performance because everytime when you hit the slicer of select any visual data complete query go back to orginal data source and fetch the result. You  dont have full capacity f calculation also. Few DAX supported in Direct query mode.

     

    If hope this post helps you please give kudos and accept it as a solution!
    Thanks