If this is the initial creation of your extract then be sure your Excel spreadsheet contains only the columns that you need in order to create the visualizations. If you are looking at a 30 megabyte Excel file, they exist, then it is going to take a long time to build. If you are updating an existing extract, then schedule the update for a time when users are not using the Tableau Workbook. Beyond that, search this forum for Best Practices when working with Extracts.
Please use the new 10.5 version and get good performance.
BI, Aspire Systems (India) Pvt Ltd
My excel sheets size greater than 50MB. So, I have imported the data to SQL Server. I have created data model by connecting to SQL Server, but when working in sheets if I drag a field to column/row pill it is processing for long time. How can I overcome this situation?
I am using Tableau 2018.1 version
Are you using a custom SQL statement that retrieves only the fields and rows that you need? Once you are getting just what you need, create an extract and schedule the update timing. It will take a while to build the extract, but once that is done you will have use of the full power of Hyper. Things should run much better.
Ok thanks for your time.
I have not used the custom sql. I will try it once.