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