Gateway Timeout Error

[PowerBI123456]

Hi - I keep getting this message when trying to refresh my model for the first time. Any idea what it can be? It keeps timing out after 2 or 3 hours. I checked advanced setting for SQL and those timeouts are above 5 hours. 

{"error":{"code":"DM_GWPipeline_Gateway_TimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_TimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}}

[Anonymous]

Not sure if this would help you. You could also ensure that the column for which you have set "Store Rows in Last:" is different from the column on which you have imposed RangeStart and RangeEnd parameters. It helped reduce my refresh time from 1.5 hrs to 10 mins. I am not clear though on what the reason was for the slow refresh

[v-robertq-msft · Accepted solution]

Hi, @PowerBI123456 

What’s your workspace’s capacity? Do you use Premium workspace? Here’s the refresh time limitation for a scheduled refresh in Power BI service:

Scheduled refresh for imported datasets timeout after two hours. This timeout is increased to five hours for datasets in Premium workspaces. If you encounter this limit, consider reducing the size or complexity of your dataset, or consider breaking the dataset into smaller pieces.

As we can see, you scheduled refresh for imported datasets timeout after two hours if you aren’t in the premium workspace. Therefore, I suggest you to upgrade your workspace to Premium workspace if you have started the PPU trail, like this:

More info about scheduled refresh timeout

Power BI Premium Per User FAQ

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@PowerBI123456 When you mentioned advanced settings, I guess you mean checking advanced setting in Power BI when you made the connection to SQL Server, correct?

[PowerBI123456]

Yup, those are set at 5 hours and my model is timing out at 2 or 3 hours

[parry2k]

@PowerBI123456 did you looked at this gateway troubleshoot document, not sure if there is anything available in that document

[PowerBI123456]

Yeah there is nothing in there about timeouts

[parry2k]

@PowerBI123456 are you pushing a lot of data? Usually, that could be the reason when you doing a bulk upload.

[PowerBI123456]

@parry2k yes it is a lot, how do you get around that then?