Forum Discussion
Error Message - Server Closed Connection Unexpectedly
Hi Anonymous ,
For existing query, please try to modify it in the Power Query Editor's Advanced Editor.
let Source = AmazonRedshift.Database("my_server", "my_db", [BatchSize = 1000]), ....Best Regards,
Winniz
Hello v-kkf-msft
Per your suggestion above, can I change the batch size to 1000 for a .pbix, I have already developed for my end users?
Screen Shot 1 & Screen Shot 2
Note: I'm currently using an ODBC connector for this existing .pbix
Screen Shot 3 & Screen Shot 4
Re: Changing the Batch size to 1000, I found Batch Size in Advance Options, but when I make the change to the size from 100 to 1000 my .pbix is prompting me to select my Sales and Revenue Table again from Redshift.
The batch size may affect the data for these tables when I pull the data in again, but I need the batch size to affect the existing .pbix I have already built. I’m currently getting the error message per my current refresh attempts.
Is there a way for me to change the batch size for my existing .pbix?
Regards,
Screen Shot 1
Screen Shot 2
Screen Shot 3
Screen Shot 4
Community SupportHi Anonymous ,
For existing query, please try to modify it in the Power Query Editor's Advanced Editor.
let
Source = AmazonRedshift.Database("my_server", "my_db", [BatchSize = 1000]),
....
Best Regards,
Winniz
Winniz
Going to give your suggestion a try.
Much appreciated
Thank you!
Hello Winniz
I'm receiving an error message, see below.
Regards,
Hello Winniz
Here is another attempt....