Update odata from Desktop get the timeout error DM_GWPipeline_Gateway_TimeoutError

[Anonymous]

After I use powerbi to obtain the odata data source of Azure devops and make a report, I cannot update the data source. When the data set is updated, an error occurs:

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

It seems that the data queried is too large, causing the update time to timeout. Is there any way to increase the timeout? Or do I have any other error, the data I'm querying has about 300,000 rows, could this data be the cause of that error?

Thanks for any help 

[Anonymous]

Hi  @Anonymous ,

This is the related document, you can view this content:

https://community.powerbi.com/t5/Service/Error-in-first-incremental-refresh-in-powerBI-com-DM-GWPipeline/td-p/1030665

https://community.powerbi.com/t5/Issues/Refresh-schedule-failures/idi-p/988513/page/2#comments

https://www.fourmoo.com/2020/06/17/power-bi-on-premise-data-gateway-error-dm_gwpipeline_gateway_spooledoperationmissingparametersdetailsexceptionculprit1/

Best Regards,

Liu Yang

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

[amitchandak]

@Anonymous , depending on connection, you can give a timeout option

https://community.powerbi.com/t5/Desktop/Query-Timeout-on-update/td-p/53459