There are 6 data sources embedded in the dashboard and I'm doing extract refresh on hourly basis. The average runtime for extract is 600 seconds. How can I find which data source is causing more runtime. Can i know extract timing for each of the datasourc

Try doing a performance recording and analyze the result https://help.tableau.com/current/server/en-us/perf_troubleshooting.htm