Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Need Support

performance details -  when we connect direct tables from multiple database is there any issue in performance?
And required performance details when we have more DAX on our report?

Need Help
Show and Tell

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , If Import mode, Performance will be decided by Power BI Model.

     

    If direct queries, across the database, can have some challenges.  Try to only single direction join. enable cache.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      If we can merge the queris in power query editor how the performance impact

      • v-kkf-msft's avatar
        v-kkf-msft
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi Anonymous ,

         

        If the data source supports query folding, then it is not recommended that you merge the query. Merging queries may prevent the transformation of query folding, thus slowing down the query load time.

         

        For more information, please refer to:

        Overview of query evaluation and query folding in Power Query 

        Power Query query folding 


        Best Regards,
        Winniz
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.