Forum Discussion

Drobinson1's avatar
Drobinson1
Helper III
7 years ago

select top performance

When bringing in direct query tables from powerbi service we see this activity from our sql database.

 

The query varies to select top[1], top[100], top[1000000].  Seems to me to be a performance hog and I am not sure how to make powerbi stop doing this.   This is not anything we did on our end on the data setup.

 

 

Need Help

1 Reply

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

    Hi Drobinson1,

     

    Please check if you have write any sql statement when connect to SQL database in data source settings before you publish report to power bi service. Or you can check if there's any sql query in power query advanced editor.

     

    Regards,

    Jimmy Tao