Forum Discussion

mhar's avatar
mhar
Frequent Visitor
5 years ago

BigQuery (BIEngine) and DirectQuery time

Hi,

 

I'm trying the new BIEngine in BigQuery together with Direct Query in PBI. BiEngine works fine and I can see that a query is returned after 500 ms. Before running the query I started performance analyzer in PBI desktop. For the same query I get 7317 ms stated as DirectQuery. This of course makes the experience much slower than imported mode. 

 

Is the conclusion that DQ is not an option against BigQuery regardless of how fast we can get the BigQuery queries to run. Or can I reduce the overhead in some way.

 

For information I have tried both having all tables (3) as DQ or have the two dimension tables as import (dual).

 

Thanks

Need Help

4 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    5 years ago

    as far as  I know imported is going to be  faster most of the time than direct query unless you have huge amounts of data then you will need to use direct query  - it will be need to be optimised use a MPP type engine which I am assuming Big Query does?

    this video is quite informative.

     

     

     

    • mhar's avatar
      mhar
      Frequent Visitor
      5 years ago

      Thanks for your answer.

       

      Yes, it's going to be faster, that is ok and expected. But BigQuery and especially now with the in-memory solution called BI Engine the query time is below 500 ms. 

       

      What I'm asking is if there is a way to reduce the 7 second (in this example) overhead? 

      Note that this question would still be relevant without BI Engine in BigQuery.