Hello friends, hope allis well!
The below code uses aSQL code to combine multi sheets (workbooks) into one sheet. This is happening on PowerPivot.
I got the idea from https://www.contextures.com/PowerPiv...cel-Files.html
Yes, there are manyrows (5 million) & 17 columns; and refreshing is taking a lotof time.
What can I do speed up the refreshing the data of the powerpivot?
btw my computer has good specs:
Windows 8.1 Pro
Installed memory (RAM)14GB
System Type: 64- bit OS,x64-based processor
Please help, and tell me howcan I speed up the refreshing process.
Thanks a lot in advance!
SELECT [HEAD$].* FROM [HEAD$]
UNION ALL
SELECT * FROM`F:\DATABASES\AvgClaimCo\17-18.xlsb`.[JAN-APR$]
UNION ALL
SELECT * FROM`F:\DATABASES\AvgClaimCo\17-18.xlsb`.[MAY-AUG$]
UNION ALL
SELECT * FROM`F:\DATABASES\AvgClaimCo\17-18.xlsb`.[SEP-DEC$]
UNION ALL
SELECT * FROM`F:\DATABASES\AvgClaimCo\16.xlsb`.[JAN-MAR$]
UNION ALL
SELECT * FROM`F:\DATABASES\AvgClaimCo\16.xlsb`.[APR-SEP$]
UNION ALL
SELECT * FROM`F:\DATABASES\AvgClaimCo\16.xlsb`.[OCT-DEC$]
UNION ALL
SELECT * FROM`F:\DATABASES\AvgClaimCo\15.xlsb`.[Jan-Mar$]
UNION ALL
SELECT * FROM`F:\DATABASES\AvgClaimCo\15.xlsb`.[Apr-Jun$]
UNION ALL
SELECT * FROM `F:\DATABASES\AvgClaimCo\15.xlsb`.[Jul-Sep$]
UNION ALL
SELECT * FROM`F:\DATABASES\AvgClaimCo\15.xlsb`.[Oct-Dec$]