question

AnujBansal-5887 avatar image
0 Votes"
AnujBansal-5887 asked Ehren commented

VBScript fails at "refreshall" statement for excel having power query when size of excel outputis around 50 MB

I am running a VB script which involves:
- Creation of folders
- Opening of Excel with power queries
- refreshing the excels to run the power queries
- saving the excels
When I am running this query on the remote server having 32 bit Office 2016 and 64 bit OS:
- it runs fine for scenario when size of output excel is ~10-20 MB
- but fails at "refreshall" statement when size of output excel is 50 MB
However in my local system with 64 bit office and 64 bit OS this query runs fine for all scenarios irrespective of output excel file size.
Is it happening due to 32 bit office or is there any other reason behind it? Please provide a solution.

power-query-not-supported
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

It's possibly due to the x86 version running low on memory. How much memory is used when refreshing? What error are you getting?

0 Votes 0 ·

0 Answers