I'm trying to get the rows that are added in the current day from a SQL Server table that contains all order data in these couple months.
I started by using 'Transform data using Power Query' to filter the data. It worked well when I first run the flow 2 months ago. The Timeout error just get more often to happen and my flow fails every time I run it because of the SQL procedure goes Timeout.
I've tried using 'Get Rows' and order it by creation time in desc, and get only a few hundred rows but the error still occur.
Is there any way I can get my data without doing anything to the SQL Server?
Thanks