TRACE STATUS SQL QUERIES

[Anonymous]

Hi Expert

I would like to know if there is any way to create a "trace" in some log, txt or other type of file to know if a query start and finish OK when i launch in power bi service.

For example, I have a pbix upload to the pbi service, but in some moment when i scheduled, have a timeout error, i try to increase the value of the timeout, but i would like to know exactly where my queries crash

Is there any workaround or possible to do this?

Thanks, Fernando

[lbendlin]

What kind of SQL source?  On-premise or Azure? Something else?

[Anonymous]

Hi!

AZURE SQL, not need to use gateway, write sql import mode direct to azure sql

thanks

[v-easonf-msft]

Hi,  @Anonymous 

Not sure if Sql Profiler could help you.

Please refer to these related posts.

SQL-Server-Profiler-processing-data-in-Power-BI 

https://blog.crossjoin.co.uk/2019/12/02/testing-performance-of-power-bi-reports-in-the-browser-part-1/ 

connecting-sql-server-profiler-to-power-bi-premium/ 

monitor-report-performance 

Best Regards,
Community Support Team _ Eason