Timed out Error while fetching data

I need to import data from ATHENA with dynamic date range. My stored data is large in size perhaps that why its giving timed out error.  I used below mentioned dynamic date range on start and end date of calender in advance filter but timedout error persisted.

>= Date.AddDays(Date.From(DateTime.LocalNow()),-180)

Any possible solution for this is appreciated.