Forum Discussion

Baskar's avatar
Baskar
Resident Rockstar
5 years ago

Direct Query performance Issue

Dear Team, 

  Need help to understand what's wrong with my model  with Direct connection ( Oracle ).
 
Source : Oracle 
Connection Type : Direct 
Table used : Team Members ( Max : 57,879Rows ) , Address ( Max : 4,00,000 Rows )
Direction : One ( Address ) to Many ( Team Members )
Used Visual : Table
 
Direct Query Executing less than 700ms , But DAX Query taking  ( 54067 ms ). 
 
Note : 
    There no DAX measure or  DAX Calculation. All the columns coming from Source.
    There is no Power Query transformation.
 
 

 

 

Even there no document from Microsoft/Blog to find what is going on there in Formula engine. 

 

Can anyone help us. 

amitchandak parry2k Greg_Deckler MFelix MattAllington Ashish_Mathur ImkeF 

 

 
 
 
Need Help

7 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Baskar ,

    Direct Query, means SQL - Please

    and For DAX, please share the columns you are using in DAX visual.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Baskar,

    Can you please share some more detail about the 'FE' part that spend most of the duration to process?

    How to Get Your Question Answered Quickly 

    In addition, have you traced the network status of remote access? It may also affect the performance if these queries are pending for network connection and delay.

    Regards,

    Xiaoxin Sheng

    • Baskar's avatar
      Baskar
      Resident Rockstar
      5 years ago

      How we can measure the FE timing ? in DAX studio. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        HI Baskar,

        FE and SE seem to mean the 'formula engine' and 'storage engine'.  Perhaps You can take a look at the following blog about the difference between the two engines:

        Formula engine and storage engine in DAX 
        Regards,

        Xiaoxin Sheng