Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Refresh Source takes time

My weekly report usually takes 10min - 20min max but all of sudden this week it takes a lot of time , running the report from past 5 hours and its still 912MB, tried it in different system it is stil...
Need Help
  • selimovd's avatar
    selimovd
    4 years ago

    Hey Anonymous ,

     

    and where is that table? In a relational table like a SQL Server or in an Excel or CSV file? Can you open the table with another tool? Does it also take long there? How many rows does it have now and how many did it have when it took 10-20 minutes? Did anything else change (Location, Index, etc.)?

     

    You should investigate the table more, then usually things will clear up.

     

    Best regards

    Denis

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi selimovd ,

 

Yes, it is a specific table but, its a weekly report, it just took 10-20min last week and this week with no additional table , no changes but takes this longer. 

selimovd's avatar
selimovd
Most Valuable Professional
4 years ago

Hey Anonymous ,

 

and where is that table? In a relational table like a SQL Server or in an Excel or CSV file? Can you open the table with another tool? Does it also take long there? How many rows does it have now and how many did it have when it took 10-20 minutes? Did anything else change (Location, Index, etc.)?

 

You should investigate the table more, then usually things will clear up.

 

Best regards

Denis