Timed out Error while fetching data

[Ved_Prakash]

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.

[amitchandak]

@Ved_Prakash , Try to increase timeout

https://community.powerbi.com/t5/Desktop/How-to-set-command-timeout-option/m-p/920420

Also, enable parallel loading in Options under -> File -> Options and Settings