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 h...
Need Help
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