Timeout Issue Online - Redshift

[hokw94]

Hi there,

My dataset is refreshing correctly in Power BI desktop but when I publish it, it fails the scheduled refresh (credentials are working and this is a new issue).

Error code 1: 

{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState 08S01] server closed the connection unexpectedly\n\tThis probably means the server terminated abnormally\n\tbefore or while processing the request.\n"}}],"exceptionCulprit":1}}} Table: my_view.

Error code 2:

{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Timeout expired. The timeout period elapsed prior to completion of the operation."}}],"exceptionCulprit":1}}} Table: my_view.

I have tried to increase the timeout limit of the query by editing the M code to add a 

[CommandTimeout=#duration(0, 1, 0, 0)]

to my M code:

let
Source = AmazonRedshift.Database("my_server", "my_db", [BatchSize = null]),

but got the following 2 errors:

1. Too many arguments, 2-3 arguments expected (I added the CommandTimeout to the end)

2. BatchSize must be specified (I tried changing BatchSize argument to CommandTimeout argument)

So how do I increase my timeout? Or do I even need to do this at all - am I barking up the wrong tree?

Thanks!

[Anonymous]

Hi @hokw94 ,

You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
If it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Best Regards,

Jay

[GilbertQ · Accepted solution]

Hi there

I would change the Batch Size to be 1000 instead of NULL, so that it can send the data in batches which should make it run faster and not wait for the entire dataset.

[amitchandak]

@hokw94 , check if the configure refresh setting is properly done. Also you might have to enable access for power bi service

https://powerbi.microsoft.com/en-us/blog/announcing-support-for-amazon-redshift-reports-in-the-power...

https://aws.amazon.com/blogs/big-data/integrate-power-bi-with-amazon-redshift-for-insights-and-analy...