Power Platform Community Forum Thread Details

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

Categories:

Using connectors