Dataflow optimization

[smpa01]

If a dataflow (gen1) contains n number of tables, is there any way progrmatic way to detect which among these n tables has the longest running query so that the DEV for optimization can focus only on that rather than going through the whole dataflow?

@AlexisOlson 

[Anonymous]

Hi, @smpa01 

May I ask if you have tried the method provided by lbendlin ? Is the method he provided applicable to you?

If the problem is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

If not, please provide more details about the problem you are experiencing and we will do our best to solve the problem you are experiencing.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

The log csv for the refresh run has details on start and end dates for each "table".