How to increase the batch size or download speed, while importing large resultset with Table Import wizard using Power Pivot RRS feed

  • Question

  • I am using SQL server 2014 SSAS running with Tabular Model. By using table import wizard, when I choose small result set it loads Power Pivot data model in single go or batch. When I remove filter in same query to have big result set to import, SQL server tabular Model internally take decision to through data in batches of 10,000 rows and then increment by 10,000 and takes half an hour to load 500,000 rows. User has Excel 2013, 64 bit machine with 8 GB RAM connected with tabular model SSAS server.

    How I can speed up the downloading for user by increasing the Batch size or any other recommendation to speedup the download speed.

    Thursday, October 15, 2015 11:51 PM