Execution Time-Out Error While Loading Data From SQL

[bds00]

Hi Team, 

I work on a project which has an exceptionally large amount of data in one table. When I try to close and apply it shows an error as shown below. 

Also, this error comes up when I try to refresh the data. 

[bds00]

A table has been created on the SQL side which includes only the required data and that table with filtered data is imported here. Mostly I need all the columns present. Is there any other way to tackle this problem?  

[Idrissshatila]

Hello @bds00 ,

Try excluding unneeded data, remove columns that you don't need for your requirements, as well as limit rows to the period that you need.

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin