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
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.