select top performance

[Drobinson1]

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.

[v-yuta-msft]

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