Forum Discussion

sotoc's avatar
sotoc
Advocate I
7 years ago
Solved

TopN with Direct Query

I am using Direct Query with up to several million rows. I am having issues creating a visual of Top 5 Industry Codes by count by highest number of Unique IDs.   I need to filter out duplicate Co...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Hi sotoc,

     

    To improve the performance, I would recommend you to write SQL query to filter and import the filtered data into power bi firstly because dax engine is much slower than sql engine.

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Hi sotoc,

 

To improve the performance, I would recommend you to write SQL query to filter and import the filtered data into power bi firstly because dax engine is much slower than sql engine.

 

Regards,

Jimmy Tao

  • sotoc's avatar
    sotoc
    Advocate I
    7 years ago

    Thanks Jimmy, I appreciate the help. 

     

    Carly